First creating the table:
CREATE TABLE `db_mcms`.`pages` (
`page_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`page_name` VARCHAR( 255 ) NOT NULL,
`page_title` VARCHAR( 255 ) NOT NULL,
`viewable` TINYINT NOT NULL,
`permission` TINYINT NOT NULL
) ENGINE = INNODB;
Now trying to insert stuff:
INSERT INTO `db_mcms`.`pages` (
`page_id` ,
`page_name`,
`page_title`,
`viewable`,
`permission`
)
VALUES ("1", "edit", "Edit Your Website", "1", "0"),
("2", "index", "Edit Index Example" "1", "0"),
("3", "newpage", "New Page", "0", "0");
Gives me the error:
#1136 - Column count doesn't match value count at row 2
What am I doing wrong guys?
You are missing a comma here:
"Edit Index Example" "1"
Replace this with
"Edit Index Example", "1"
mysql> insert into users values(
-> 1,'真水无香','111','李华','请问今天中午吃了啥','鸭血粉丝汤','男','1987-07-12','789765432@qq.com',4,'2012-02-14','2016-08-29',17307699870,'江苏省','F:\PHP\项目七\image\1.jpg','否','否'),
-> ('禹司凤','222','成毅','hello,world','你好,世界','男','1990-09-21','234598012@qq.com',3,'2017-09-21','2019-09-23',16690756432,'河北省','F:\PHP\项目七\image\2.jpg','否','否'),
-> ('褚璇玑','333','袁冰妍','司凤,你看看我','不看','女','1988-06-21','567345780@qq.com',6,'2015-05-21','2019-09-24',18358097654,'河南省','F:\PHP\项目七\image\3.jpg','是','是');
ERROR 1136 (21S01): Column count doesn't match value count at row 2
mysql>
那我这是什么错误,就是每一个sql语句的1,2,3(即id值)我都设置了主键和自动编号,可为什么下一个sql句的id值还有自己输入啊??