Difference between revisions of "sqlite3 insert or update"
From thelinuxwiki
(Created page with " Create Index on Multiple Columns index on multiple columns CREATE INDEX index_name ON tab_name (column1, column2) add an index on the columns "firstname" and "lastname"...") |
Latest revision as of 18:47, 8 August 2017
Create Index on Multiple Columns
index on multiple columns
CREATE INDEX index_name ON tab_name (column1, column2)
add an index on the columns "firstname" and "lastname"
CREATE INDEX index_firstandlastname ON tab (firstname, lastname)
