mysql 1064 error

yuchangtao110

CREATE TABLE `BD`.`member` (
  `id` INT  NOT NULL,
  `name` VARCHAR  NOT NULL,
  `birthday` DATE  NOT NULL,
  `start` DATE  NOT NULL,
  `email` VARCHAR  NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE = InnoDB
COMMENT = 'all the member of xxx';

报错信息：
Error executing SQL commands to create table.
MySQL Error Nr. 1064
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 'NOT NULL,
  `birthday` DATE  NOT NULL,
  `start` DATE  NOT NULL,
  `email` VARCH' at line 3

终端和mysql browser都不好使  不知道啥原因 高手指教啊

love100

1. CREATE TABLE `BD`.`member` (
   
2.   `id` INT  NOT NULL,
   
3.   `name` VARCHAR(20)  NOT NULL,
   
4.   `birthday` DATE  NOT NULL,
   
5.   `start` DATE  NOT NULL,
   
6.   `email` VARCHAR(50)  NOT NULL,
   
7.   PRIMARY KEY (id)
   
8. )ENGINE = InnoDB COMMENT = 'all the member of xxx';

复制代码

please try

1. mysql> CREATE TABLE `BD`.`member` (
   
2.     ->   `id` INT  NOT NULL,
   
3.     ->   `name` VARCHAR(20)  NOT NULL,
   
4.     ->   `birthday` DATE  NOT NULL,
   
5.     ->   `start` DATE  NOT NULL,
   
6.     ->   `email` VARCHAR(50)  NOT NULL,
   
7.     ->   PRIMARY KEY (id)
   
8.     -> )ENGINE = InnoDB COMMENT = 'all the member of xxx';
   
9. Query OK, 0 rows affected (0.09 sec)
   
10. 
    
11. mysql>

复制代码

yuchangtao110

thank u 多谢老大 正解

ruochen

呵呵