On 9 September 2010 12:22, tigermain <tigerm...@gmail.com> wrote: > > In MS SQL I would use > > SET IDENTITY INSERT ON > > How do I do something similar in SQLite. I am trying to upgrade a database > and want to maintain the IDs from the original
You choose whether to include the key as part of the insert statement. SQLite version 3.6.11 Enter ".help" for instructions sqlite> create table tst( id integer primary key, data text ); sqlite> insert into tst( data ) values( 'd1' ); -- key assigned by sqlite sqlite> insert into tst( data ) values( 'd2' ); sqlite> sqlite> select * from tst; 1|d1 2|d2 sqlite> sqlite> insert into tst( id, data ) values( 101, 'd101' ); -- key in insert statement sqlite> insert into tst( id, data ) values( 102, 'd102' ); sqlite> sqlite> select * from tst; 1|d1 2|d2 101|d101 102|d102 sqlite> sqlite> sqlite> insert into tst( data ) values( 'd103' ); -- key assigned by sqlite sqlite> sqlite> select * from tst; 1|d1 2|d2 101|d101 102|d102 103|d103 sqlite> > > Thanks > -- Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
