+ -
当前位置:首页 → 问答吧 → Column count doesn't match value count at row 1

Column count doesn't match value count at row 1

时间:2011-08-31

来源:互联网

SQL code
DROP TABLE IF EXISTS category;
CREATE TABLE category(
  id smallint(6) unsigned NOT NULL auto_increment,
  cid smallint(6) unsigned NOT NULL default '0',
  model tinyint(1) unsigned NOT NULL default '0',
  name char(50) NOT NULL default '',
  PRIMARY KEY  (id)
)ENGINE=MYISAM CHARSET=utf8;

INSERT INTO category VALUES (0,1,'a');
INSERT INTO category VALUES (0,2,'b');
INSERT INTO category VALUES (0,3,'c');
INSERT INTO category VALUES (0,4,'d');
INSERT INTO category VALUES (0,5,'e');


Column count doesn't match value count at row 1

作者: cooc123   发布时间: 2011-08-31

INSERT INTO category(cid,model,name) VALUES (0,1,'a');

作者: yananguo_1985   发布时间: 2011-08-31

INSERT INTO category(cid,model,name) VALUES (0,1,'a');
or
INSERT INTO category(cid,model,name) VALUES (null,0,1,'a');

作者: WWWWA   发布时间: 2011-08-31

引用 1 楼 yananguo_1985 的回复:

INSERT INTO category(cid,model,name) VALUES (0,1,'a');

不写字段名不可以?

作者: cooc123   发布时间: 2011-08-31

INSERT INTO category VALUES (null,0,1,'a');

作者: WWWWA   发布时间: 2011-08-31

SQL语法中,如果你不按顺序提供所有的字段值,则必须要写字段

作者: ACMAIN_CHM   发布时间: 2011-08-31

加上列名

作者: rucypli   发布时间: 2011-08-31