首先，建个表：

CREATE TABLE artist(
  artistid    INTEGER PRIMARY KEY,--主键，每次insert时让它自动加1
  artistname  TEXT
);@H_404_3@ 

insert语句这样写： 
 
 
insert into artist (artistid,artistname) values ((SELECT last_insert_rowid())+1,'a');
insert into artist (artistid,'b');@H_404_3@ 

结果是： 
 
artistid  artistname---------- ----------1     a    2     b