mysql - 尝试执行查询时 SQL 语法错误

Question

 INSERT INTO `2018_players`(`p_id`, `player_fname`, `player_lname`, `stats_id`, `home_id`) VALUES (
  (1, 'LeBron', 'James', 2, 3, 23),
  (2, 'Stephen', 'Curry', 4, 5, 30),
  (3, 'James', 'Harden', 6, 7, 13),
  (4, 'Giannis', 'Antekokounmpo', 8, 9, 34),
  (5, 'Paul', 'George', 10, 11, 13);

服务器版本:5.7.23

分析过程中发现 1 个错误。

#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 '' at line 7

Answer 1

您指定了 5 列，但尝试每行插入 6 个值，并且 VALUES 后面有一个额外的括号，您需要类似以下内容:

 INSERT INTO `2018_players`(`p_id`, `player_fname`, `player_lname`, `stats_id`, `home_id`, `extra_column`) VALUES 
  (1, 'LeBron', 'James', 2, 3, 23),
  (2, 'Stephen', 'Curry', 4, 5, 30),
  (3, 'James', 'Harden', 6, 7, 13),
  (4, 'Giannis', 'Antekokounmpo', 8, 9, 34),
  (5, 'Paul', 'George', 10, 11, 13);