嗨,我收到错误1136列计数与第1行的valaue计数不匹配,我花了很长时间检查和反复检查数据、逗号等,我一生都不明白为什么会出现这个错误。这是我的表和INSERT命令:
CREATE TABLE EDITORS (
Username VARCHAR(100),
EName VARCHAR(320),
Email VARCHAR(40),
DOB DATE,
blogTitle VARCHAR(80),
PRIMARY KEY (Username)
);
INSERT INTO EDITORS (Username,EName,Email,DOB,blogTitle) VALUES (
'john360','johnWest','jwest360@yahoo.co.uk','1980-08-23','MyGeneralBlog',
'paul22344','paulWells','psmith@yahoo.co.uk','1960-09-20','PaulsBlog',
'chrisB123','chrisBenson','cb360@hotmail.co.uk','1990-10-14','MyBlog'
);
任何帮助都将不胜感激
感谢
您必须将数据拆分为如下行:
INSERT INTO EDITORS (Username,EName,Email,DOB,blogTitle) VALUES
('john360','johnWest','jwest360@yahoo.co.uk','1980-08-23','MyGeneralBlog'),
('paul22344','paulWells','psmith@yahoo.co.uk','1960-09-20','PaulsBlog'),
('chrisB123','chrisBenson','cb360@hotmail.co.uk','1990-10-14','MyBlog');
插入多个记录的语法是错误的
您可以使用:
单一声明
INSERT INTO EDITORS (Username,EName,Email,DOB,blogTitle)
VALUES
('john360','johnWest','jwest360@yahoo.co.uk','1980-08-23','MyGeneralBlog'),
('paul22344','paulWells','psmith@yahoo.co.uk','1960-09-20','PaulsBlog'),
('chrisB123','chrisBenson','cb360@hotmail.co.uk','1990-10-14','MyBlog');
或
多重声明
INSERT INTO EDITORS (Username,EName,Email,DOB,blogTitle)
VALUES ('john360','johnWest','jwest360@yahoo.co.uk','1980-08-23','MyGeneralBlog')
INSERT INTO EDITORS (Username,EName,Email,DOB,blogTitle)
VALUES ('paul22344','paulWells','psmith@yahoo.co.uk','1960-09-20','PaulsBlog')
INSERT INTO EDITORS (Username,EName,Email,DOB,blogTitle)
VALUES ('chrisB123','chrisBenson','cb360@hotmail.co.uk','1990-10-14','MyBlog')
源
使用VALUES语法的INSERT语句可以插入多行。到要执行此操作,请包含多个列值列表,每个列值都包含在括号,并用逗号分隔。
INSERT INTO EDITORS (Username,EName,Email,DOB,blogTitle) VALUES
('john360','johnWest','jwest360@yahoo.co.uk','1980-08-23','MyGeneralBlog'),
('paul22344','paulWells','psmith@yahoo.co.uk','1960-09-20','PaulsBlog'),
('chrisB123','chrisBenson','cb360@hotmail.co.uk','1990-10-14','MyBlog');