求救 高手 sql语句出现错误,具体的建表语句如下:
create table user(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
password VARCHAR(32) NOT NULL,
age INT NOT NULL,
sex VARCHAR(2) NOT NULL DEFAULT '男'
birthday DATE
);执行后出现以下的错误,求改正啊。。
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 'birth
day DATE
)' at line 7
------解决方案--------------------
create table user(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
password VARCHAR(32) NOT NULL,
age INT NOT NULL,
sex VARCHAR(2) NOT NULL DEFAULT '男', ------!!!
birthday DATE
);