mysql5.1.48 ubuntu10.10 表结构如下CREATE TABLE user (
uid int(11) NOT NULL auto_increment,
username varchar(50) NOT NULL,
password varchar(50) NOT NULL,
email varchar(50),
state bool default 0,
PRIMARY KEY (uid)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;插入语句:
insert into user values ("Joy","123","")
insert into user values ("Joy","123","",0)
报错,非要插入全部字段才正确,恶心,从没碰到的问题。大家帮帮我吧。
uid int(11) NOT NULL auto_increment,
username varchar(50) NOT NULL,
password varchar(50) NOT NULL,
email varchar(50),
state bool default 0,
PRIMARY KEY (uid)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;插入语句:
insert into user values ("Joy","123","")
insert into user values ("Joy","123","",0)
报错,非要插入全部字段才正确,恶心,从没碰到的问题。大家帮帮我吧。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货