How do you get a DATETIME column to default to NOW()? I'd like for any insert or LOAD DATA to write the time into this column without the SQL having to specify this explicitly.
ALTER TABLE `table` CHANGE `c_lastupdate` `c_lastupdate` TIMESTAMP( 14 ) NOT NULL
Is this possible? Thanks!
