- 论坛徽章:
- 0
|
本帖最后由 清楚山下 于 2016-12-12 19:30 编辑
在Linux下建立MySQL数据库,但是出现了错误
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 '(
member1_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (member1_' at line 2
mysql> CREATE TABLE member1
-> (
-> member1_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
-> PRIMARY KEY (member1_id),
-> last_name VARCHAR(20) NOT NULL,
-> first_name VARCHAR(20) NOT NULL,
-> suffix VARCHAR(5) NULL,
-> expiration DATE NULL DEFAULT '0000-00-00',
-> eamil VARCHAR(100) NULL,
-> street VARCHAR(50) NULL,
-> city VARCHAR(50) NULL,
-> state VARCHAR(2) NULL,
-> zip VARCHAR(10) NULL,
-> phone VARCHAR(20) NULL,
-> interests VARCHAR(255) NULL
-> );
|
|