Also, if you initialise a TIMESTAMP field with NULL, MySQL puts the current
time into it - for the first such field in the record only. (p109 of Paul
DuBois book - sorry, www.mysql.com seems to have gone down so I can't get a
documentation URL).
Alec
> >Is there a way to have the timestamp automatically inserted when an
> >insert statement is run? The timestamp of the insert statement.
> Try now()
Hisseine
----- Original Message -----
From: "chad kellerman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 9:59 AM
Subject: easy question
Hello,
I am sure this is an easy question but I am not thinking clearly for
some
reason. :^)
If you set a column to auto_Increment. You do not have to put the
auto_increment # in the insert statement to get it to be inserted. Mysql
does this automatically.
Is there a way to have the timestamp automatically inserted when an
insert statement is run? The timestamp of the insert statement.
thanks for the help,
chad
--
Chad Kellerman
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
