Quoting "Rowling, Jill" <[EMAIL PROTECTED]>: > I've found in general the default values are only applied if you attempt > to > insert without even mentioning the things that you want to take on > default > values. This is pretty much what James says. > > eg (this is a table of engineering drawing issues): > INSERT INTO dwg_issue (id, dwgissue) VALUES (NULL, "A01"); > > In this case I'm making a new record and only specifying one value. > All > other column values in this record (if it has any) should take on > default > values, if specified as such when the table was created. > BUT! Timestamp may be a special case. >
Big Thanks to you Jill. I tried your suggestion, by using similar syntax. And it worked. Many thanks once more. By describing my fields first and then values... (excluding my created column) it inputs the creation timestamp as requested). woohoo :) -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
