mysql - 创建表生成错误代码 1064

Question

我在尝试创建表时遇到错误代码 1604。代码是这样的:

USE Rudinas; 
CREATE TABLE clan (
first_name VARCHAR(30) NOT NULL, 
last_name VARCHAR(30) NOT NULL, 
city VARCHAR(30) NOT NULL,
country VARCHAR(30) NOT NULL,
zip MEDIUMINT UNSIGNED NOT NULL, 
birth_date DATE NOT NULL
sex ENUM("M", "F") NOT NULL,
clan_belong ENUM('EU', 'ASIAPAC', 'USA', 'SLO') NOT NULL,
date_entered TIMESTAMP,
relative_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY); 

如何让这个表运行？

Answer 1

在 birth_date DATE NOT NULL 之后使用逗号(,)

CREATE TABLE clan (
first_name VARCHAR(30) NOT NULL, 
last_name VARCHAR(30) NOT NULL, 
city VARCHAR(30) NOT NULL,
country VARCHAR(30) NOT NULL,
zip MEDIUMINT UNSIGNED NOT NULL, 
birth_date DATE NOT NULL,
sex ENUM("M", "F") NOT NULL,
clan_belong ENUM('EU', 'ASIAPAC', 'USA', 'SLO') NOT NULL,
date_entered TIMESTAMP,
relative_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY);