mysql创建数据表

以下为创建MySQL数据表的SQL通用语法：

CREATE TABLE table_name (column_name column_type);

以下例子中我们将在 RUNOOB 数据库中创建数据表runoob_tbl：

CREATE TABLE IF NOT EXISTS `runoob_tbl`(
   `runoob_id` INT UNSIGNED AUTO_INCREMENT,
   `runoob_title` VARCHAR(100) NOT NULL,
   `runoob_author` VARCHAR(40) NOT NULL,
   `submission_date` DATE,
   PRIMARY KEY ( `runoob_id` )
)；

当我想通过CREATE TABLE login(）；创建一个不知是什么的、想当然的空数据表时，出现错误

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 ')' at line 6

通过一步步删掉和添加里面的语句，发现里面必须有： 

                                        `runoob_id` INT UNSIGNED AUTO_INCREMENT,

                                             PRIMARY KEY ( `runoob_id` )

     ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key