sql语法错误
- 错误信息
[Err] 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 ‘(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT’ at line 5 - 解决方法:
- 数据库版本太低了,把timestamp(0)中的(0)去掉,
另外在mysql5.5中如果sql文件中有datetime(0)也一样要去掉(0)