> The portable (and correct) way to do it is to use the DEFAULT keyword > like this: > > INSERT INTO some_table (id_field) VALUES (DEFAULT);
Alternatively, for columns for which you have no value, don't specify them at all in the insert. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
