alter table t_user alter column create_date set default CURRENT_TIMESTAMP; 报错(idea生成的sql)

[42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP' at line 1.

解决方案:

ALTER TABLE t_user MODIFY COLUMN create_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
原文地址:https://www.cnblogs.com/javalinux/p/14312861.html