最近博客会有大变动哦,敬请期待~ (最近也不知道是要多久,鸽鸽鸽)

MENU

mysql #1064 报错

July 28, 2019 • Read: 50 • 不想分类

mysql5.6向5.5导入数据时报错

#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 '0000-00-00 00:00:00', `comment_date_gmt` datetime(0) NO' at line 8

低版本sql datetime不需要设置疏忽长度 将数据类型后面的(0)删除