Tutorial SQLite
#8

Pentru auto increment se foloseste coloana INTEGER PRIMARY KEY AUTOINCREMENT, nu stiu daca SA-MP suporta asa ceva, iar pentru primary key coloana INTEGER PRIMARY KEY; ii confirmat ca functioneaza.
Acum ca ai un primary key, query-ul tau ar trebui sa arate cam asa cand selectezi ceva.
Код:
SELECT `coloanaprimarykey` FROM `tabel` WHERE `coloana` = 'ceva';
Ai selectat mai putine date si mai rapid datorita acelei coloane speciale, deci mai putin de procesat .
Reply


Messages In This Thread
Tutorial SQLite - by Zh3r0 - 08.05.2011, 18:20
Re: Tutorial SQLite - by Paul.eboy - 08.05.2011, 18:46
Re: Tutorial SQLite - by SkizzoTrick - 08.05.2011, 18:53
Re: Tutorial SQLite - by dcs.Mihai - 08.05.2011, 19:33
Re: Tutorial SQLite - by gabitzu4ever - 09.05.2011, 09:34
Re: Tutorial SQLite - by [NoV]LaZ - 09.05.2011, 12:50
Re: Tutorial SQLite - by Zh3r0 - 09.05.2011, 14:43
Re: Tutorial SQLite - by [NoV]LaZ - 09.05.2011, 15:55
Re: Tutorial SQLite - by xxmitsu - 09.05.2011, 16:05
Re: Tutorial SQLite - by Zh3r0 - 09.05.2011, 16:17

Forum Jump:


Users browsing this thread: 2 Guest(s)