mysql - phpmyadmin 的 SQL 错误语法

Question

你好，

我在为我的数据库使用 phpmyadmin 时遇到问题，我是新手，这是来自 previewmysql 的 mysql 结构:

CREATE TABLE `mydb`.`attendant` 
  ( 
     `id`             INT NOT NULL auto_increment, 
     `first_name`     VARCHAR(20) NOT NULL, 
     `names`          VARCHAR(50) NOT NULL, 
     `gender`         ENUM(0) NOT NULL, 
     `email`          VARCHAR(20) NOT NULL, 
     `phone`          INT(15) NULL, 
     `marital_status` ENUM(0) NOT NULL, 
     `added_date`     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 
     `membership`     ENUM(0) NOT NULL, 
     `address`        VARCHAR(20) NOT NULL, 
     `suburb`         ENUM(0) NOT NULL, 
     `partner_name`   VARCHAR(25) NULL, 
     PRIMARY KEY (`id`), 
     UNIQUE `email_address` (`email`) 
  ) 
engine = innodb; 

错误是:

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 '0) NOT NULL , `email` VARCHAR(20) NOT NULL , `phone` INT(15) NULL , `marital_sta' at line 1

还附上了我的 phpmyadmin 表结构。 将不胜感激。

Answer 1

Try it.Hope errors goes boom.I just fixed your errors. But your table structure is not good enough. give time, then day by day you will also be expert on it.

  CREATE TABLE `mydb`.`attendant` 
  ( 
     `id`             INT NOT NULL auto_increment, 
     `first_name`     VARCHAR(20) NOT NULL, 
     `names`          VARCHAR(50) NOT NULL, 
     `gender`         ENUM('0','1') NOT NULL, 
     `email`          VARCHAR(20) NOT NULL, 
     `phone`          INT(15),
     `marital_status` ENUM('0','1') NOT NULL, 
     `added_date`     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 
     `membership`     ENUM('0','1') NOT NULL, 
     `address`        VARCHAR(20) NOT NULL, 
     `suburb`         ENUM('0','1') NOT NULL, 
     `partner_name`   VARCHAR(25) NULL, 
     PRIMARY KEY (`id`), 
     UNIQUE `email_address` (`email`) 
  ) 
engine = innodb;