mysql - 单个查询命令

Question

我正在将 csv 文件内容放入数据库中。当我在命令下手动运行时..它工作正常..但是当我在命令提示符下输入单个查询时，它没有运行。

mysql -uuser -ppassword -hlocalhost -e "LOAD DATA INFILE "C:\csvfile.csv" 
INTO TABLE test.LoadedEmployee FIELDS TERMINATED BY "," ENCLOSED BY '' 
ESCAPED BY '\\' LINES TERMINATED BY "\n" STARTING BY ''"

仅供引用..有效的手动语法:

mysql -uuser -ppassword -hlocalhost 
LOAD DATA INFILE "C:\csvfile.csv" INTO TABLE test.LoadedEmployee 
FIELDS TERMINATED BY "," ENCLOSED BY '' ESCAPED BY '\\' 
LINES TERMINATED BY "\n" STARTING BY ''

Answer 1

如果你想加载 CSV 文件然后试试这个:仅供引用这将忽略第一行 - 标题。

LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;