View source for sqlite3 insert or update

← sqlite3 insert or update

Jump to: navigation, search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this 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)

Return to sqlite3 insert or update.

Retrieved from "http://www.thelinuxwiki.com/index.php/sqlite3_insert_or_update"

Navigation menu