when doing INSERT automatically add NOW

[YBH305]

Hey,

I'm wondering if its possible when I do an INSERT to automatically add the DATETIME/NOW() ?

Currently I'm doing it through my script itself

INSERT INTO table (id, userid, currentDate)
VALUES (1, 1, NOW())

What I'm looking for is something like this:

INSERT INTO table (id, userid)
VALUES (1, 1)

Not sure? thanks!

[r937]

read up on the DEFAULT VALUE CURRENT_TIMESTAMP option in the CREATE TABLE statement in the manual, it gives an example