主页 / dba / 问题 / 175062
Accepted
John Biddle
Asked: 2017-06-01 09:38:12 +0800 CST

无法调试这个简单的 SQL 语句

  • 772

我正在使用 LOAD DATA LOCAL INFILE 将数据导入 MySQL 表。我在另一张桌子上毫不费力地完成了这个，我复制了 stmt，只是更改了表名和字段。这是声明：

LOAD DATA LOCAL INFILE '/John/league_seasons.csv'
INTO TABLE lwl_league_players
IGNORE 1 LINES
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
(id, location_id, game_id, league_season_id, player_id);

这是错误：

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 'FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
(id, location_id, game_id,' at line 4

FIELDS TERMINATED BY 和 LINES TERMINATED BY 行与我之前的工作语句完全相同。我检查了结构，没问题。

表结构

我很感激有人指出我搞砸了的地方。谢谢

mysql phpmyadmin

1 个回答

  1. Best Answer

    选项的顺序很重要。

    放置IGNORE 1 LINES后，接下来应该是列列表。

    LOAD DATA LOCAL INFILE '/John/league_seasons.csv'
INTO TABLE lwl_league_players
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(id, location_id, game_id, league_season_id, player_id);

    请参阅有关语法的 MySQL 文档，您将看到选项的正确顺序。

    • 1

相关问题