BSD/Linux & Tips & Tricks SquallBSR on 28 Jan 2007 05:24 pm
Auto Incrementing Database Fields
postgres: create table t( id serial, data text, primary key (id) ); mysql: create table t( id int(11) not null auto_increment, data text, primary key (id) ); sqlite: create table t( id integer primary key, data text, );