DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`(
`id` INT 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','teacher'),
(3,'admin','123456','admin'));
顯示欄位數不匹配是啥意思啊 這明明對的啊
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
13:20:21 INSERT INTO `user` VALUES( (1,'111111','123456','student'), (2,'aaaaaa','123456','teacher'), (3,'admin','123456','admin')) Error Code: 1136. Column count doesn't match value count at row 1 0.000 secuj5u.com熱心網友回復：
知道了，多寫了個括號 我去uj5u.com熱心網友回復：
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/59347.html
標籤：MySQL