DROP TABLE IF the EXISTS ` user `; 
The CREATE TABLE ` user ` (
` id ` INT the NOT NULL AUTO_INCREMENT, 
` uid ` CHAR (12) DEFAULT NULL, 
` password ` VARCHAR (12) DEFAULT NULL, 
` card ` CHAR (10) DEFAULT NULL, 
PRIMARY KEY (id) 
) ENGINE=INNODB DEFAULT CHARSET=UTF8; 
INSERT INTO ` user ` VALUES (
(1, '111111', '123456', 'student'), 
(2, 'aaaaaa', '123456', 'the teacher'), 
(3, 'admin', '123456', 'admin')); 

Show the field number does not match what is meaning clearly this right

CodePudding user response:

CodePudding user response:

13:20:21 INSERT INTO ` user ` VALUES (1, '111111', '123456', 'student'), (2, 'aaaaaa', '123456', 'the teacher'), (3, 'admin', '123456', 'admin')) the Error Code: 1136. The Column count doesn 't match the value count at row 1, 0.000 SEC

CodePudding user response:

I know it, write the parenthesis

CodePudding user response: