sqlite自增:ROWID

前端之家收集整理的这篇文章主要介绍了sqlite自增:ROWID前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

ROWIDs and the INTEGER PRIMARY KEY

Every row of every sqlite table has a 64-bit signed integer key that uniquely identifies the row within its table. This integer is usuallycalled the "rowid". The rowid value can be accessed using one of the specialcase-independent names "rowid","oid",or "_rowid_" in place of a column name.If a table contains a user defined column named "rowid","oid" or "_rowid_",then that name always refers the explicitly declared column and cannot be usedto retrieve the integer rowid value.

The data for each table in sqlite is stored as a B-Tree structure containingan entry for each table row,using the rowid value as the key. This means thatretrieving or sorting records by rowid is fast. Searching for a record with aspecific rowid,or for all records with rowids within a specified range isaround twice as fast as a similar search made by specifying any other PRIMARYKEY or indexed value.

With one exception,if a table has a primary key that consists of a single column,and the declared type of that column is "INTEGER" in any mixture of upper and lower case,then the column becomes an alias for the rowid. Such acolumn is usually referred to as an "integer primary key". A PRIMARY KEY columnonly becomes an integer primary key if the declared type name is exactly"INTEGER". Other integer type names like "INT" or "BIGINT" or "SHORT INTEGER"or "UNSIGNED INTEGER" causes the primary key column to behave as an ordinarytable column with integer @L_301_0@ and a unique index,not as an alias for the rowid.


红色部分:如果主键为INTEGER,则the columnrowidalias

猜你在找的Sqlite相关文章