MySQL一直出现这个问题

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;

img