Feed on Posts or Comments

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,
);

Trackback This Post | Subscribe to the comments through RSS Feed

Leave a Reply