datafaker icon indicating copy to clipboard operation
datafaker copied to clipboard

Published 20 hours ago • verified publisher icon gangly

mysql 的 datetime 插入数据显示语法错误，

Open zeroone2005 opened this issue 5 years ago • 2 comments

sqlalchemy.exc.ProgrammingError: (MySQLdb._exceptions.ProgrammingError) (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 '11:28:15,0),(2,'dingjie',56.58,'玉华市',40383614455,'姜雷',2019-12-11 11:28' at line 1")

日期没有添加引号好像是这个问题

zeroone2005 avatar Dec 11 '19 03:12 zeroone2005

把元文件内容发出来看下

gangly avatar Dec 11 '19 08:12 gangly

本地mysql测试过没问题， image

image

gangly avatar Dec 11 '19 16:12 gangly