*if you create a column of the type TIMESTAMP instead of DATETIME then it
automatically stores the time when the record was inserted/last updated. If
you have more that one column of type TIMESTAMP in the same table then only
the first TIMESTAMP column gets updated automatically. (Don't confuse
Thanks Paul, that works great.
Yes, I meant to say the table animals, not bug_master.
Paul DuBois
Great, this is more of what I was looking fora way to have the DB auto
populate the date/time in a column, without having to use sql.
Thanks again!
Uttam
At 8:37 -0600 3/15/03, [EMAIL PROTECTED] wrote:
I have a table called animals (using the example in the MySQL guide). I have a
datetime column type.
Here is the table:
Looks like it's called bug_master, not animals. :-)
create table bug_master (
id MEDIUMINT NOT NULL