揮発性のメモ2

http://d.hatena.ne.jp/iww/

autoincrementを指定する

SQLite Frequently Asked Questions

create table t1( a int primary key AUTOINCREMENT, b int );


次の書き方はNG

create table t3( a int AUTOINCREMENT, b int, primary key(a) );
create table t3( a int, b int, primary key AUTOINCREMENT(a) );