MySQL CURRENT_TIMESTAMP on create and on update

mysql timestamp mysql-error-1293

Guess this is a old post but actually i guess mysql supports 2 TIMESTAMP in its recent editions mysql 5.6.25 thats what im using as of now.

mysql timestamp mysql-error-1293

i think it is possible by using below technique

`ts_create` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',`ts_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

mysql timestamp mysql-error-1293

You are using older MySql version. Update your myqsl to 5.6.5+ it will work.

CodeHunter