Nighthawk: 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"..."

2017-08-08T18:47:44Z

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"..."

New page

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)

sqlite3 insert or update - Revision history

Nighthawk: 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"..."