[plug] MYSQL and the Date

levsky at rave.iinet.net.au levsky at rave.iinet.net.au
Sat Feb 1 23:28:46 WST 2003


On Sat, Feb 01, 2003 at 11:23:22PM +0800, Leon Brooks wrote:
> On Saturday 01 February 2003 11:02 pm, Andrew Barbara wrote:
> > Is there a way to get mysql to add the date automatically when it adds an
> > entry?  similar to the auto-increment.
> 
> I think 'now' is the portable way to do it.

Yeah - that works too - but I thought he was asking as a default.
You of course can go insert into test (id,ts) values (1,now());

Cheers

Mark

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



More information about the plug mailing list