https://www.sqlite.org/lang_createtable.html#rowid
The above link websit is very valuable.
Thanks for Quan Yong Zhai.







At 2015-12-14 19:08:59, "Quan Yong Zhai" <qydi at msn.com> wrote:
>https://www.sqlite.org/lang_createtable.html#rowid
>________________________________
>???: ???<mailto:2004wqg2008 at 163.com>
>????: ?2015/?12/?14 18:21
>???: sqlite-users at mailinglists.sqlite.org<mailto:sqlite-users at 
>mailinglists.sqlite.org>
>??: [sqlite] Very Strange and Interesting Problem
>
>hi, every one.
>     Here is a very strange and interesting problem.
>     I used the following SQL to create the table teacher.
>     CREATE TABLE techer(poiId INTEGER NOT NULL PRIMARY KEY,
>                                            versionId INTEGER NOT NULL,
>                                            regionId INTEGER ,
>                                            postalCode TEXT ,
>                                            phone TEXT ,
>                                            attrBitMask INTEGER ,
>                                            attributeBlob BLOB)
>
>     and  then I used the following SQL,
>     select rowid,*  from teacher.    So the strange and interesting problem 
> happen.
>     the name of the rowid column change to poiId, and the name of the poiId 
> become poiId_1. But the two columns have the same values.
>
>     Why the rowid change is column name?
>     Is the problem reasonable ?  How do you think about this problem? why?
>     I  am looking forward to hearing from you.
>
>     Best regards.
>         WQG
>
>
>
>
>
>
>
>
>_______________________________________________
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>_______________________________________________
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to