mysql> CREATE TABLE user(
-> id int(10) unsigned not null auto_increment,
-> name varcher(25),
-> sex varcher(5),
-> age int(10),
-> password varcher(25),
-> primary key(id)engine=Innodb;
ERROR 1064 (42000): 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 'varcher(25),
sex varcher(5),
age int(10),
password varcher(25),
primary key(id)e' at line 3
name varchar,不是varcher
单词都拼错了
CREATE TABLE user(
id int unsigned not null auto_increment,
name nvarchar(32),
sex nvarchar(32),
age int,
password nvarchar(32),
primary key(id)engine=Innodb;
括号都是对等的,你数数你是不是少了个小括号。
这语法错误很明显啊,随便找个现有的表对比一下就知道了,下面这个语法才是正确的
CREATE TABLE user(
id int unsigned not null auto_increment,
name nvarchar(32),
sex nvarchar(32),
age int,
password nvarchar(32),
primary key(id) )
engine=Innodb;