Auto Date in table

[S.Dickson]

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]

S.*******@shos.co.uk wrote:

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/...functions.html

[Bill Karwin]

S.*******@shos.co.uk wrote:

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/...stamp-4-1.html

Regards,
Bill K.