Auto Date in table

[S***@shos.co.uk]

I have a mysql table, with a field called DATE, how do i get it to
automatilly put the date on it every time a new recored it put on the
table

Date and time would be good,


Tahnks

[strawberry]

Post by S***@shos.co.uk
I have a mysql table, with a field called DATE, how do i get it to
automatilly put the date on it every time a new recored it put on the
table
Date and time would be good,
Tahnks

Have a read through the user comments posted at

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

[Bill Karwin]

Post by S***@shos.co.uk
I have a mysql table, with a field called DATE, how do i get it to
automatilly put the date on it every time a new recored it put on the
table

You can do this automatically with the TIMESTAMP datatype, but not with
the DATE datatype.

Read the documentation about TIMESTAMP:
http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html

Regards,
Bill K.