首页DROP TABLE IF EXISTS `order`; CREATE TABLE `order` ( `order_id` int(11) NOT NULL AUTO_INCREMENT, `order_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `order_product_addnumber` int(11) NOT NULL, PRIMARY KEY (`order_id`) USING BTREE, ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;的错误是什么

DROP TABLE IF EXISTS `order`; CREATE TABLE `order` ( `order_id` int(11) NOT NULL AUTO_INCREMENT, `order_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `order_product_addnumber` int(11) NOT NULL, PRIMARY KEY (`order_id`) USING BTREE, ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;的错误是什么

时间: 2023-10-21 08:03:41 浏览: 72

数据库脚本OrderDB

/*员工人事表*/ print'creat table Employee' go CREATE TABLE Employee( employeeNo char(8) not null /*员工编号*/ check(employeeNo like '[E][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'), employeeName varchar(10) not null, /*员工姓名*/ sex char(1) not null, /*员工性别*/ birthday datetime null, /*员工生日*/ address varchar(50) null, /*员工住址*/ telephone varchar(20) null, /*员工电话*/ hireDate datetime not null, /*雇佣日期*/ department varchar(30) not null, /*所属部门*/ headShip varchar(10) not null, /*职务*/ salary numeric(8,2) not null, /*薪水*/ constraint EmployeePK primary key (employeeNo) ) go

这段语句有一个错误。在创建`order`表的语句中，最后也是有一个逗号，导致语法错误。正确的语句应该是： ``` DROP TABLE IF EXISTS `order`; CREATE TABLE `order` ( `order_id` int(11) NOT NULL AUTO_INCREMENT, `order_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `order_product_addnumber` int(11) NOT NULL, PRIMARY KEY (`order_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; ```

阅读全文