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
