[plug] MYSQL and the Date

levsky at rave.iinet.net.au levsky at rave.iinet.net.au
Sat Feb 1 23:04:22 WST 2003


On Sat, Feb 01, 2003 at 11:02:59PM +0800, Andrew Barbara wrote:
> Hi all,
> Is there a way to get mysql to add the date automatically when it adds an 
> entry?  similar to the auto-increment.

Yes - create the column not null, and then don't specify the column in the
insert - it'll default to the current date.

-- 
Old MacDonald had a form
e_i ^ e_i = 0



More information about the plug mailing list