首先，建个表： 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
| 