On 2006-0728 16:07:47, Nemanja Corlija wrote: > You can insert default value like this: > insert into test (f) values (NULL); > > Inserting NULL into autoincrement field just increments it. While > omitting value for any other field uses default for that field, if one > is defined.
next question: is there a way to ask which was the last (autoincremented) value inserted in the table? or is there a guarantee that this works, as it seems... select max(f) from test; -- Defeat is worse than death, because you have to live with defeat.