计算机2202

Source Server : localhost_3306
Source Server Version : 80032
Source Host : localhost:3306
Source Database : stu_python

Target Server Type : MYSQL
Target Server Version : 80032
File Encoding : 65001

Date: 2023-06-26 17:17:18
*/

SET FOREIGN_KEY_CHECKS=0;

– Table structure for itinerary

DROP TABLE IF EXISTS itinerary;
CREATE TABLE itinerary (
ydcs varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
xcsj varchar(64) DEFAULT NULL,
ydjd varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
yxjd varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
xccp varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

– Records of itinerary

INSERT INTO itinerary VALUES (‘丽江1’, ‘约11时55分’, ‘归隐·花园美宿’, ‘丽江古城’, ‘长春-丽江’, ‘1’);
INSERT INTO itinerary VALUES (‘昆明’, ‘约8时55分’, ‘君享酒店’, ‘滇池’, ‘长春-昆明’, ‘2’);
INSERT INTO itinerary VALUES (‘大理’, ‘约8时25分’, ‘夜阑雨客栈’, ‘崇圣寺三塔’, ‘长春-大理’, ‘3’);
INSERT INTO itinerary VALUES (‘玉溪’, ‘约13时12分’, ‘通海滇南大酒店’, ‘玉溪通海秀山公园’, ‘长春-玉溪’, ‘4’);
INSERT INTO itinerary VALUES (‘大理’, ‘约8时25分’, ‘双廊致家客栈’, ‘洱海’, ‘长春-大理’, ‘5’);
INSERT INTO itinerary VALUES (‘云南’, ‘5:30’, ‘香格里拉酒店’, ‘香格里拉·’, ‘H234’, ‘9’);