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!
read up on the DEFAULT VALUE CURRENT_TIMESTAMP option in the CREATE TABLE statement in the manual, it gives an example