首先,建个表: CREATE TABLE artist( artistid INTEGER PRIMARY KEY, --主键,每次insert时让它自动加1 artistname TEXT ); insert语句这样写: insert into artist (artistid,artistname) values ((SELECT last_insert_rowid())+1,'a'); insert into artist (artistid,artistname) values ((SELECT last_insert_rowid())+1,'b'); 结果是: artistid artistname ---------- ---------- 1 a 2 b
|