When doing INSERT automatically add NOW

Databases
1

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!

2

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