![]() ![]() ![]() The requirement is that the email and phone must be unique. Suppose you have to manage contacts using SQLite.Įach contact has the following information: Note that the primary key of a table is a column or a group of columns that uniquely identify each row in the table. Note that the WITHOUT ROWID option is only available in SQLite 3.8.2 or later. A table that contains the rowid column is known as a rowid table. If you don’t want SQLite creates the rowid column, you specify the WITHOUT ROWID option. The rowid column stores a 64-bit signed integer key that uniquely identifies the row inside the table. By default, a row in a table has an implicit column, which is referred to as the rowid, oid or _rowid_ column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |