create table teacher ( id int(4) primary key not null unique auto_increment, num int(10) not null unique, name varchar(20) not null, sex varchar(4) not null, birthday datetime, address varchar(50) ); 我只是好简单的插入语句 insert into teacher values (1,1000,'张三',‘男','1988-01-01','china'); 却显示出错的,无法插入数据错误提示 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','1988-01-01','china')' at line 1
忘记对你们说我是用虚拟机,系统安装了win 2003 EE
如果 insert into teacher values (1,1000,'张三',‘男','1988-01-01','china'); 我用select * from teacher name 与 sex 字段都是 ? ,他们插入的数据都是中文。其它字段一切正常。我想问为何这样的。
create table teacher ( id int(4) primary key not null unique auto_increment,
num int(10) not null unique,
name varchar(20) not null,
sex varchar(4) not null,
birthday datetime,
address varchar(50)
);
我只是好简单的插入语句
insert into teacher values (1,1000,'张三',‘男','1988-01-01','china'); 却显示出错的,无法插入数据错误提示 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','1988-01-01','china')' at line 1
忘记对你们说我是用虚拟机,系统安装了win 2003 EE
我用select * from teacher
name 与 sex 字段都是 ? ,他们插入的数据都是中文。其它字段一切正常。我想问为何这样的。