- 论坛徽章:
- 0
|
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都不好使 不知道啥原因 高手指教啊 |
|