And in case you didn't know, SQLite tables have a built-in rowid column. If you declare a column INTEGER PRIMARY KEY it becomes an alias for it. So if you don't have an alias for it, you can use:
SELECT rowid, * FROM table
Quote:
Originally Posted by zokemon
You should make account PRIMARY KEY rather then UNIQUE to speed up indexing (makes SELECT go faster)
|
You just got told, by Riot.