[sqlite] why i get the value of ROWID is equal to the value of field created as Primary key?

i create a table in sqlite3 with the SQL query: CREATE TABLE a(sn INTEGER primary key, name TEXT). and add some records as follows, sn | name 11 | Jos 13 | Mar 15 | Sor using SQL query: SELECT * FROM a, i get the number of fields is 2. it is normal,

Re: [sqlite] why i get the value of ROWID is equal to the value of field created as Primary key?

On Wed, Jan 2, 2013 at 2:00 AM, genliu777 doityth...@163.com wrote: is it the meaning of the field created as INTEGER primary is alias to the hidden ROWID field? 3rd paragraph in http://www.sqlite.org/lang_createtable.html#rowid -- D. Richard Hipp d...@sqlite.org