代码之家 › 专栏 › 技术社区 › MishaVacic

在MySQL错误1064中插入第9行的“(4,Yahoo,user4 yahooid)”

mysql

MishaVacic · 技术社区 · 8 年前

   CREATE TABLE profile_contact
(
profile_id     INT UNSIGNED NOT NULL, 
service        CHAR(20) NOT NULL, 
contact_name   CHAR(25) NOT NULL, 
);

然后,我想插入mysql中的行

mysql> INSERT INTO profile_contact
    -> (profile_id,service,contact_name)
    -> VALUES
    -> (1,AIM,user1-aimid),
    -> (1,MSN,user1-msnid),
    -> (2,AIM,user2-aimid),
    -> (2,MSN,user2-msnid),
    -> (2,Yahoo,user2-yahooid)
    -> (4,Yahoo,user4-yahooid);

但我犯了个错误

ERROR 1064 (42000): 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 '(4,Yahoo,user4-yahooid)' at line 9

1 回复 | 直到 8 年前

Darshan Mehta 8 年前

您的脚本在最后一个值后缺少逗号 (2,Yahoo,user2-yahooid) 因此,误差。以下内容应适用:

CREATE TABLE profile_contact(
profile_id     INT UNSIGNED NOT NULL, 
service        CHAR(20) NOT NULL, 
contact_name   CHAR(25) NOT NULL
);

INSERT INTO profile_contact
-> (profile_id,service,contact_name)
-> VALUES
-> (1,'AIM','user1-aimid'),
-> (1,'MSN','user1-msnid'),
-> (2,'AIM','user2-aimid'),
-> (2,'MSN','user2-msnid'),
-> (2,'Yahoo','user2-yahooid'),
-> (4,'Yahoo','user4-yahooid');

P、 S.中的最后一列 CREATE 剧本此外,价值观如 AIM

这是 SQL Fiddle .