用记事本新建文本,另存为CSV(编码UTF-8):
1,2,3
A,B,C
D,E,F
然后在workbench 6.3CE里面用内置的import工具导入,得到下面结果:
Restoring C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\3.csv
Running: mysql.exe --defaults-file="c:\users\admin\appdata\local\temp\tmpw34unc.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "C:\\ProgramData\\MySQL\\MySQL Server 5.7\\Uploads\\3.csv"
ERROR 1064 (42000) at line 1: 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 '1,2,3
A,B,C
D,E,F' at line 1Operation failed with exitcode 1
17:40:41 Import of C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\3.csv has finished with 1 errors想不通,请高人指点,我现在只能先建个一样字段的表,然后删除CSV的标题部分,然后用load data infile的方法才能导入
1,2,3
A,B,C
D,E,F
然后在workbench 6.3CE里面用内置的import工具导入,得到下面结果:
Restoring C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\3.csv
Running: mysql.exe --defaults-file="c:\users\admin\appdata\local\temp\tmpw34unc.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "C:\\ProgramData\\MySQL\\MySQL Server 5.7\\Uploads\\3.csv"
ERROR 1064 (42000) at line 1: 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 '1,2,3
A,B,C
D,E,F' at line 1Operation failed with exitcode 1
17:40:41 Import of C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\3.csv has finished with 1 errors想不通,请高人指点,我现在只能先建个一样字段的表,然后删除CSV的标题部分,然后用load data infile的方法才能导入
如果是这样,那导入用的文件第一行是不是不能包含标题?因为我看load data infile 方法里面没有甄别有无标题的选项
然则import和load data infile实际上是一个功能吗?import实际上也是用load data?
请大神帮忙看下4楼,我说的对不对
mysql.exe --defaults-file="c:\users\admin\appdata\local\temp\tmpw34unc.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "C:\\ProgramData\\MySQL\\MySQL Server 5.7\\Uploads\\3.csv"你这是一个执行 sql 的操作,要执行的 sql 是从你要导入的文件中获取的,而你的文件中写的是数据,不是 sql ,所以不知道你那个操作怎么弄出来的