On 15 Nov 2011, at 11:27am, Luciano de Souza wrote: > With the clause "integer primary key", we can create an autoincrementable > field in Sqlite. Other databases uses auto_increment, serial and something > else. > > If I am not wrong, Sqlite uses also auto_int. But, if I would build a > database readable by other databases, what is the best way to create an > autoincrementable field?
Unfortunately for you, there is no part of the SQL specification which defines how to define a column as an autoincrementable field. Each company is free to do it however it wishes: SQLite spells a word 'AUTOINCREMENT' and MySQL spells it 'AUTO_INCREMENT', one standard uses the text 'GENERATED BY DEFAULT AS IDENTITY' but almost no engines support that exact phrase. So unfortunately this is one of the parts of SQL which you have to do differently depending on which SQL engine you use. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
