ON UPDATE CURRENT TIMESTAMP cannot be unset on TIMESTAMP column
Database management in a single PHP file
Brought to you by:
jakubvrana
Menu
▾
▴
#459 ON UPDATE CURRENT TIMESTAMP cannot be unset on TIMESTAMP column
closed-rejected
nobody
4
2017-02-20
2015-06-05
No
When creating and altering a table, I deliberately left the CURRENT_TIMESTAMP option unselected for the (ON UPDATE) drop-down but, when viewing a structure dump of the table, it always shows as if I had selected it. I tried updating the table, selecting then unselecting it, but nothing works, I cannot remove the ON UPDATE CURRENT_TIMESTAMP from the column definition without issuing a raw SQL command, or using another tool like phpMyAdmin.
This is in the MySQL-only version of Adminer.
never mind, mysql 5.0 issue