主页 > 编程资料 > Delphi >
发布时间:2015-09-22 作者:网络 阅读:132次

首先,建个表:

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


关键字词: