[SQL] Query jdbc_imooc start
[ERR] 1007 - Can't create database 'jdbc_imooc'; database exists
[ERR] CREATE DATABASE jdbc_imooc;
USE jdbc_imooc;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `hotel`;
CREATE TABLE `hotel` (
`orderno` int(11) NOT NULL PRIMARY KEY,
`city` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`price` float(6, 2) NOT NULL,
`hotelname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`arrivedate` date NULL DEFAULT NULL,
`leavedate` date NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 ;
-- ----------------------------
-- Records of hotel
-- ----------------------------
INSERT INTO `hotel` VALUES (10001, '����', 659, '�Ƶ�1', '2011-5-8','2011-5-11');
INSERT INTO `hotel` VALUES (10002, '�Ϻ�', 799, '�Ƶ�2', '2019-11-11','2019-11-15');
INSERT INTO `hotel` VALUES (10003, '����', 455, '�Ƶ�3', '2020-5-1','2020-5-4');
INSERT INTO `hotel` VALUES (10004, '�Ϻ�', 699, '�Ƶ�4', '2019-5-4','2019-5-7');
SET FOREIGN_KEY_CHECKS = 1;
[SQL] Finished with erro
恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星