CREATE TABLE `new_schema`.`tb_books` (
`id` INT UNSIGNED NOT NULL DEFAULT ID编号,
`name` VARCHAR(45) NOT NULL DEFAULT '图书名称',
`price` DOUBLE NOT NULL DEFAULT 价格,
`bookCount` INT UNSIGNED NOT NULL DEFAULT 数量,
`author` VARCHAR(45) NOT NULL DEFAULT '作者');
想创建数据表但是失败了,怎么解决?出现如下错误:
ERROR 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 'ID编号,
`name` VARCHAR(45) NOT NULL DEFAULT '图书名称',
`price` DOUBLE' at line 2
`id` INT UNSIGNED NOT NULL DEFAULT ID编号,
`name` VARCHAR(45) NOT NULL DEFAULT '图书名称',
`price` DOUBLE NOT NULL DEFAULT 价格,
`bookCount` INT UNSIGNED NOT NULL DEFAULT 数量,
`author` VARCHAR(45) NOT NULL DEFAULT '作者');
想创建数据表但是失败了,怎么解决?出现如下错误:
ERROR 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 'ID编号,
`name` VARCHAR(45) NOT NULL DEFAULT '图书名称',
`price` DOUBLE' at line 2