RE: Newbie - How can I insert new data with the current date/time?

2003-03-16 Thread Uttam
*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

Re: Newbie - How can I insert new data with the current date/time?

2003-03-16 Thread KKolle
Thanks Paul, that works great. Yes, I meant to say the table animals, not bug_master. Paul DuBois

RE: Newbie - How can I insert new data with the current date/time?

2003-03-16 Thread KKolle
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

Re: Newbie - How can I insert new data with the current date/time?

2003-03-15 Thread Paul DuBois
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