没有问题mysql> use haha;
Database changed
mysql> create table article(
-> id int NOT NULL auto_increment,
-> title varchar(255) NOT NULL,
-> content text NOT NULL,
-> author varchar(20) NOT NULL,
-> email varchar(30) NOT NULL,
-> date varchar(40) NOT NULL,
-> primary key(id),
-> );
Query OK, 0 rows affected (0.53 sec)mysql> desc article;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| title | varchar(255) | | | | |
| content | text | | | | |
| author | varchar(20) | | | | |
| email | varchar(30) | | | | |
| date | varchar(40) | | | | |
+---------+--------------+------+-----+---------+----------------+
6 rows in set (0.08 sec)
Database changed
mysql> create table article(
-> id int NOT NULL auto_increment,
-> title varchar(255) NOT NULL,
-> content text NOT NULL,
-> author varchar(20) NOT NULL,
-> email varchar(30) NOT NULL,
-> date varchar(40) NOT NULL,
-> primary key(id),
-> );
Query OK, 0 rows affected (0.53 sec)mysql> desc article;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| title | varchar(255) | | | | |
| content | text | | | | |
| author | varchar(20) | | | | |
| email | varchar(30) | | | | |
| date | varchar(40) | | | | |
+---------+--------------+------+-----+---------+----------------+
6 rows in set (0.08 sec)
)把,去掉试试 , 我发现有 , 和没 , 都不错出, 但楼主的MYSQL的提示错误出现在末尾的,上?