search

mailgyc / doudizhu

html5 斗地主游戏
https://m.ihouser.com
481 stars 207 forks source link

数据库问题 #15

Closed cuican008 closed 5 years ago

cuican008 commented 5 years ago

mysql --user=root -p < schema.sql Enter password: ERROR 1293 (HY000) at line 5: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

mailgyc commented 5 years ago

可能是MySQL版本问题，在5.7 下面是可以的。 你可以试试 updated_date 换成下面： updated_date TIMESTAMP ON UPDATE TIMESTAMP