SQL查询错误,
问题描述:
还没有找到一个答案,类似于我的查询SQL查询错误,
这一个朋友俚语词典应用程序,所以请不要将获得由愚蠢的语言
SQL查询生气:
(
'A', 'Assc', 'Assclown', 'Assclown - verb, adjective - one who makes a complete fool of themselves or is just generally a moron. Closely related to asshat. ALT. SPELLING:ass clown. USAGE: Listen up assclown, you my friend are an untalented hack!'
);
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 ''A', 'Assc', 'Assclown','Assclown - verb, adjective - one who makes a complete f' at line 1
--
-- Dumping data for table `countries`
--
INSERT INTO `dictionary` (`Letter`, `ID`, `Word`, `Definition`) VALUES
('A', 'As', 'Ass Out','Ass Out - verb, adjective - to be poor, have no money. USAGE: Man I am ass out this month. I
aint got no kinda funds coming through here.');
('A', 'Assc', 'Assclown','Assclown - verb, adjective - one who makes a complete fool of themselves or is just
generally a moron. Closely related to asshat. ALT. SPELLING:ass clown. USAGE: Listen up assclown, you my friend are
('A', 'Autob', 'Autoburial','Autoburial - noun - the state of being given the antithesis of autopush; that is to
receive no favoritism at all. ANT: autopush SYN: baller-blocking, hatred USAGE: My instructor was hating and gave
the entire class massive autoburial on our midterm grades.')
答
问题是分号(;
)你用来分离值集。您必须改用逗号(,
)。
答
问题出在语法上,请替换;与, INSERT数据集分离
这是整个查询吗? – Ladadadada
否,但查询的其余部分仅仅是格式相同的'a'单词列表 –