SLUG Mailing List Archives
RE: [SLUG] fustrations with mysql (TIMESTAMP)
- To: "Rowling, Jill" <Rowling@xxxxxxxxxx>
- Subject: RE: [SLUG] fustrations with mysql (TIMESTAMP)
- From: Michael Fox <michael@xxxxxxxxxx>
- Date: Tue Dec 17 16:45:02 2002
- Cc: slug@xxxxxxxxxxx
- User-agent: IMP/PHP IMAP webmail program 2.2.7
Quoting "Rowling, Jill" <Rowling@xxxxxxxxxx>:
> I've found in general the default values are only applied if you attempt
> insert without even mentioning the things that you want to take on
> 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.
> other column values in this record (if it has any) should take on
> 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
By describing my fields first and then values... (excluding my created column)
it inputs the creation timestamp as requested).