From: Tim Dudgeon <tdudgeon@in...> - 2007-03-26 15:25:20
I have a HSQLDB table with an IDENTITY column as the primary key.
I want to insert a new row that is blank - no values other than the
auto-generated PK value. How do I do this?
insert into FOO (FOO_ID) VALUES (DEFAULT)
insert into FOO () VALUES ()
don't seem to work, whereas one or the others seems to work for some
other DBs. What is the syntax I need?
Get latest updates about Open Source Projects, Conferences and News.