mysql不支持双引号
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 '"ROADNO" SMALLINT NOT NULL ,
"ROADNAME" CHAR(8) NOT NULL ,
' at line 3, Time: 0.082000s
"去掉或者改为`
navicat 导入 csv乱码
- 使用10008的gb2312字符!
- https://blog.csdn.net/qq_27762917/article/details/77578123
然后日期格式要注意
- 改为-和.分隔
不支持WITH DEFAULT 0
- mysql要改为 DEFAULT 0