Re: Equivalent for AUTOINCREMENT?

pardon me, I didn't read the post - just judged it by subject really :)

you can also use keyward DEFAULT, so insert into foo(a) values(default);

But that's the whole point of DEFAULT .... in create table statement. If you omit that column, it will be set to default value.