Tag Archives: triggers

Managing Timestamps in MySQL with a Trigger

MySQL doesn’t support having two columns with time stamping on both initialization and/or on updating at the same time. It would be nice to be able to do *this* where the created_at column gets the current_timestamp on initialization and the updated_at gets changed on updating the row. # like so doesn't work... create table entries( body [...]
Posted in Databases | Also tagged , , , | 2 Comments