mysql初学者练习题（从基础到进阶，相关数据sql脚本在最后）
1、使用DDL语句创建airticket数据库，并切换到airticket数据库
2、使用DDL语句创建如下5个表，注意约束
create table aircompany( companyID int(11) primary key, companyName varchar(50), address varchar(50), hotLine varchar(50));
create table cabin( cabinID int(11) primary key, fightID varchar(50), grade varchar(20) not null, seats int(11),availableSeats int(11),fullPrice decimal(10,2));
create table passenger( identityID varchar(20) primary key, name varchar(50) not null, genger varchar(4), birthday date,tel varchar(20));
create table ticketsell( ordersID int(11) primary key, identityID varchar(20), fightID varchar(50), fightDate date,grade varchar(20),seat varchar(20),price decimal(10,2), gate varchar(20));
3、使用DDL语句修改passenger表的结构
a）为tel列添加唯一约束，约束名为uni_tel
alter table passenger add constraint uni_tel unique(tel);
b）将tel的数据类型改为varchar(11)
alter table passenger modify tel varchar(11);
c）将gender列修改为sex，数据类型修改为varchar(10)
alter table passenger change genger sex varchar(10);
d）添加一新列address，数据类型为varchar(50)
alter table passenger add address varchar(50);
4、使用DDL语句修改ticketSell表的结构
a）为该表的identityID列添加外键约束，约束名为fk_identityID，该列值引用passenger表的 identityID
alter table ticketSell add constraint fk_identityID foreign key (identityID) references passenger(identityID);
b）删除外键约束fk_identityID
alter table ticketSell drop foreign key fk_identityID;
c）将ticketSell表名更改为ticketSale
rename table ticketSell to ticketSale;
5、删除所有表，删除数据库airticket
单表查询
- 查询乘客的姓名、身份证、电话
SELECT name, identityID, tel from passenger;
- 查询里程数在1500以上的航班信息，按里程数升序排列
SELECT * from flight where mileage > 1500 ORDER BY mileage;
- 查询电话以13开头，并且性别为男的乘客信息
SELECT * from passenger WHERE tel LIKE '13%' and gender='男';
- 查询起始城市是武汉，到达城市是北京的航班信息
SELECT * from flight where fromCity = '武汉' and toCity = '北京';
- 查询飞行日期为2019年的销售信息
SELECT * FROM ticketsell WHERE YEAR(flightDate) = 2019;
- 统计航班为'HU7188'的飞机票平均销售金额
SELECT avg(price) from ticketsell where flightID ='HU7188';
- 统计航班'MU5102'的飞机票销售总金额
SELECT sum(price) from ticketsell where flightID ='MU5102';
- 统计不同航班的机票销售票数
SELECT flightID,count(flightID) as num from ticketsell GROUP BY flightID;
- 统计不同航班不同舱位等级的机票销售金额
SELECT flightID,grade,sum(price) as num from ticketsell GROUP BY flightID,grade ORDER BY flightID;
- 统计'MU'开头的航班，不同舱位等级的机票销售金额
SELECT flightID,grade,sum(price) as num from ticketsell where flightID LIKE 'MU%' GROUP BY flightID,grade ORDER BY flightID;
Select多表连接练习：
- 查询'山东航空'公司所有的航班信息
SELECT a.companyName,f.flightID,a.companyID,model,fromCity,toCity,mileage,departureTime from flight as f INNER JOIN aircompany as a on f.companyID = a.companyID where f.companyID = 9 ;
2、查询'苏彦博'的所有飞行记录
SELECT `name`,ordersID,p.identityID,flightID,flightDate,grade,seat,price,gate from passenger as p INNER JOIN ticketsell as t on p.identityID = t.identityID where p.`name` = '苏彦博'
3、查询'中国东方航空'公司不同舱位等级的销售次数
SELECT t.grade,COUNT(t.grade) from ticketsell as t INNER JOIN flight as f on t.flightID = f.flightID INNER JOIN aircompany as a
on a.companyID = f.companyID where a.companyName = '中国东方航空' GROUP BY t.grade
4、查询不同航班，不同舱位等级的销售次数，显示销售次数在三次及以上的信息，按销售次数升序
SELECT flightID,grade,num from (
SELECT flightID,grade,COUNT(flightID) as num from ticketsell GROUP BY flightID,grade) as o where num >= 3 ORDER BY num;
5、查询所有航班信息及航班的销售信息
SELECT f.flightID,a.companyID,f.model,f.fromCity,f.toCity,f.mileage,f.departureTime,t.ordersID,t.identityID,t.identityID
,t.flightID,t.flightDate,t.grade,t.seat,t.price,t.gate from aircompany as a INNER JOIN flight as f on a.companyID = f.companyID INNER JOIN ticketsell as t on f.flightID = t.flightID;
6、查询从武汉飞往北京的航班信息，要求显示航班号、航空公司名称、机型、始发地、目的地、里程 数和起飞时间，按照起飞时间升序显
SELECT t.flightID as '航班号',a.companyName as '航空公司' ,f.model as '机型',f.fromCity as '始发地',f.toCity as '目的地',f.mileage as '里程数',f.departureTime as '起飞时间' from ticketsell as t INNER JOIN flight as f on t.flightID = f.flightID INNER JOIN aircompany as a
on a.companyID = f.companyID where f.fromCity = '武汉' and f.toCity = '北京' order by f.departureTime;
Select子查询练习：
- 查询公里数比北京到上海高的航班信息
WITH t1 AS (
SELECT MAX(mileage) AS max_mileage
FROM flight
WHERE fromCity = '北京' AND toCity = '上海'
)
SELECT c.*, f.*
FROM cabin AS c
INNER JOIN flight AS f ON c.flightID = f.flightID
WHERE f.mileage > (SELECT max_mileage FROM t1);
- 查询'中国国际航空'公司的销售信息
SELECT * from ticketsell where flightID = (SELECT f.flightID from aircompany as a INNER JOIN flight as f on
- companyID=f.companyID where companyName ='中国国际航空' );
- 查询票价高于平均价格的销售信息
SELECT * from ticketsell where price > (SELECT avg(price) from ticketsell)
- 旅客查询南京至西安所有航班的剩余票数
SELECT * from cabin where flightID = (SELECT flightID from flight where fromCity = '南京' and toCity = '西安' )
5、机场管理人员查询所有9号，由武汉飞往北京的所有航班的机票销售情况，要求显示不同航班不同舱 位等级的机票销售信息
SELECT flightID as '航班号', grade as '舱位等级',COUNT(ordersID) as '已售票数' from ticketsell where day(flightDate) = 9 and flightID in
(SELECT flightID from flight where fromCity='武汉' and toCity = '北京');
6、查询票价比所有经济舱都要高的销售数据
SELECT * from ticketsell where price > (SELECT MAX(price) from ticketsell where grade = '经济舱' );
7、查询票价比任意商务舱都要低的销售数
SELECT * from ticketsell where price < (SELECT MAX(price) from ticketsell where grade = '商务舱' );
数据脚本：
/*
Navicat MySQL Data Transfer
Source Server : myconn
Source Server Version : 50605
Source Host : localhost:3306
Source Database : airticket
Target Server Type : MYSQL
Target Server Version : 50605
File Encoding : 65001
Date: 2025-08-31 21:01:24
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `aircompany`
-- ----------------------------
DROP TABLE IF EXISTS `aircompany`;
CREATE TABLE `aircompany` (
`companyID` int(11) NOT NULL AUTO_INCREMENT,
`companyName` varchar(50) DEFAULT NULL,
`address` varchar(50) DEFAULT NULL,
`hotLine` varchar(50) DEFAULT NULL,
PRIMARY KEY (`companyID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of aircompany
-- ----------------------------
INSERT INTO `aircompany` VALUES ('1', '中国南方航空', '广州市机场路278号', '95539');
INSERT INTO `aircompany` VALUES ('2', '中国东方航空', '上海市虹桥路2550号', '95530');
INSERT INTO `aircompany` VALUES ('3', '中国国际航空', '北京市顺义区天柱路30号', '95583');
INSERT INTO `aircompany` VALUES ('4', '海南航空', '海口市国兴大道7号', '950718');
INSERT INTO `aircompany` VALUES ('5', '深圳航空', '深圳宝安国际机场航站四路2033号', '95080');
INSERT INTO `aircompany` VALUES ('6', '厦门航空', '厦门市埭辽路22号', '95557');
INSERT INTO `aircompany` VALUES ('7', '吉祥航空', '上海市虹翔三路80号', '95520');
INSERT INTO `aircompany` VALUES ('8', '四川航空', '成都市武侯区二环路南四段六号', '400-830-0999');
INSERT INTO `aircompany` VALUES ('9', '山东航空', '济南二环东路5746号', '400-609-6777');
-- ----------------------------
-- Table structure for `cabin`
-- ----------------------------
DROP TABLE IF EXISTS `cabin`;
CREATE TABLE `cabin` (
`cabinID` int(11) NOT NULL AUTO_INCREMENT,
`flightID` varchar(50) DEFAULT NULL,
`grade` varchar(20) NOT NULL,
`seats` int(11) DEFAULT NULL,
`availableSeats` int(11) DEFAULT NULL,
`fullPrice` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`cabinID`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of cabin
-- ----------------------------
INSERT INTO `cabin` VALUES ('1', 'MU294', '头等舱', '4', '4', '2600.00');
INSERT INTO `cabin` VALUES ('2', 'MU294', '商务舱', '8', '8', '2200.00');
INSERT INTO `cabin` VALUES ('3', 'MU294', '经济舱', '172', '172', '1610.00');
INSERT INTO `cabin` VALUES ('6', 'MU2540', '头等舱', '2', '2', '2900.00');
INSERT INTO `cabin` VALUES ('7', 'MU2540', '商务舱', '6', '6', '2500.00');
INSERT INTO `cabin` VALUES ('8', 'MU2540', '经济舱', '154', '154', '1610.00');
INSERT INTO `cabin` VALUES ('9', 'MU2885', '头等舱', '2', '2', '2780.00');
INSERT INTO `cabin` VALUES ('10', 'MU2885', '商务舱', '6', '6', '2120.00');
INSERT INTO `cabin` VALUES ('11', 'MU2885', '经济舱', '162', '162', '1080.00');
INSERT INTO `cabin` VALUES ('12', 'CA1947', '头等舱', '8', '8', '2750.00');
INSERT INTO `cabin` VALUES ('13', 'CA1947', '商务舱', '12', '12', '2230.00');
INSERT INTO `cabin` VALUES ('14', 'CA1947', '经济舱', '270', '270', '1610.00');
INSERT INTO `cabin` VALUES ('15', 'MU2453', '商务舱', '16', '16', '1580.00');
INSERT INTO `cabin` VALUES ('16', 'MU2453', '经济舱', '140', '138', '1080.00');
INSERT INTO `cabin` VALUES ('17', 'CZ3117', '头等舱', '4', '4', '2100.00');
INSERT INTO `cabin` VALUES ('18', 'CZ3117', '商务舱', '12', '12', '1620.00');
INSERT INTO `cabin` VALUES ('19', 'CZ3117', '经济舱', '142', '141', '1080.00');
INSERT INTO `cabin` VALUES ('21', 'MU2451', '商务舱', '16', '16', '1480.00');
INSERT INTO `cabin` VALUES ('22', 'MU2451', '经济舱', '148', '146', '1080.00');
INSERT INTO `cabin` VALUES ('24', 'HU7188', '头等舱', '6', '5', '2320.00');
INSERT INTO `cabin` VALUES ('25', 'HU7188', '商务舱', '12', '11', '1730.00');
INSERT INTO `cabin` VALUES ('26', 'HU7188', '经济舱', '140', '137', '1080.00');
INSERT INTO `cabin` VALUES ('27', 'HU7291', '商务舱', '16', '16', '3420.00');
INSERT INTO `cabin` VALUES ('28', 'HU7291', '经济舱', '144', '144', '1740.00');
INSERT INTO `cabin` VALUES ('29', 'HU7309', '头等舱', '4', '4', '3830.00');
INSERT INTO `cabin` VALUES ('30', 'HU7309', '商务舱', '12', '12', '3290.00');
INSERT INTO `cabin` VALUES ('31', 'HU7309', '经济舱', '150', '150', '1740.00');
INSERT INTO `cabin` VALUES ('32', 'CZ6356', '头等舱', '6', '6', '3820.00');
INSERT INTO `cabin` VALUES ('33', 'CZ6356', '商务舱', '12', '12', '3180.00');
INSERT INTO `cabin` VALUES ('34', 'CZ6356', '经济舱', '139', '139', '1740.00');
INSERT INTO `cabin` VALUES ('35', 'ZH9438', '商务舱', '20', '20', '3260.00');
INSERT INTO `cabin` VALUES ('36', 'ZH9438', '经济舱', '156', '156', '1740.00');
INSERT INTO `cabin` VALUES ('37', 'ZH9516', '商务舱', '12', '12', '2880.00');
INSERT INTO `cabin` VALUES ('38', 'ZH9516', '经济舱', '170', '170', '1900.00');
INSERT INTO `cabin` VALUES ('39', 'ZH9602', '商务舱', '16', '16', '2760.00');
INSERT INTO `cabin` VALUES ('40', 'ZH9602', '经济舱', '158', '158', '1900.00');
INSERT INTO `cabin` VALUES ('41', 'MF8073', '商务舱', '9', '9', '2820.00');
INSERT INTO `cabin` VALUES ('42', 'MF8073', '经济舱', '151', '151', '1900.00');
INSERT INTO `cabin` VALUES ('43', 'MF8069', '头等舱', '6', '6', '3680.00');
INSERT INTO `cabin` VALUES ('44', 'MF8069', '商务舱', '16', '16', '2710.00');
INSERT INTO `cabin` VALUES ('45', 'MF8069', '经济舱', '140', '140', '1900.00');
INSERT INTO `cabin` VALUES ('46', 'SC1191', '商务舱', '12', '12', '3220.00');
INSERT INTO `cabin` VALUES ('47', 'SC1191', '经济舱', '146', '146', '1880.00');
INSERT INTO `cabin` VALUES ('51', 'SC4873', '商务舱', '9', '9', '3320.00');
INSERT INTO `cabin` VALUES ('52', 'SC4873', '经济舱', '148', '148', '1880.00');
INSERT INTO `cabin` VALUES ('53', '3U8948', '头等舱', '6', '6', '3880.00');
INSERT INTO `cabin` VALUES ('54', '3U8948', '商务舱', '12', '12', '3250.00');
INSERT INTO `cabin` VALUES ('55', '3U8948', '经济舱', '142', '142', '1880.00');
INSERT INTO `cabin` VALUES ('56', 'HO1252', '商务舱', '8', '8', '1680.00');
INSERT INTO `cabin` VALUES ('57', 'HO1252', '经济舱', '174', '174', '1130.00');
INSERT INTO `cabin` VALUES ('58', 'MU5102', '头等舱', '12', '12', '3890.00');
INSERT INTO `cabin` VALUES ('59', 'MU5102', '商务舱', '24', '24', '2680.00');
INSERT INTO `cabin` VALUES ('60', 'MU5102', '经济舱', '296', '296', '1130.00');
INSERT INTO `cabin` VALUES ('61', 'CZ3907', '头等舱', '9', '9', '3770.00');
INSERT INTO `cabin` VALUES ('62', 'CZ3907', '商务舱', '20', '20', '2630.00');
INSERT INTO `cabin` VALUES ('63', 'CZ3907', '经济舱', '302', '302', '1130.00');
INSERT INTO `cabin` VALUES ('64', 'HO1284', '商务舱', '12', '12', '2820.00');
INSERT INTO `cabin` VALUES ('65', 'HO1284', '经济舱', '170', '170', '1600.00');
INSERT INTO `cabin` VALUES ('66', 'CZ6553', '头等舱', '4', '4', '3890.00');
INSERT INTO `cabin` VALUES ('67', 'CZ6553', '商务舱', '16', '16', '2990.00');
INSERT INTO `cabin` VALUES ('68', 'CZ6553', '经济舱', '156', '156', '1600.00');
INSERT INTO `cabin` VALUES ('69', 'MU5680', '商务舱', '20', '20', '2780.00');
INSERT INTO `cabin` VALUES ('74', 'MU5680', '经济舱', '276', '276', '1600.00');
-- ----------------------------
-- Table structure for `flight`
-- ----------------------------
DROP TABLE IF EXISTS `flight`;
CREATE TABLE `flight` (
`flightID` varchar(50) NOT NULL,
`companyID` int(11) DEFAULT NULL,
`model` varchar(50) DEFAULT NULL,
`fromCity` varchar(50) DEFAULT NULL,
`toCity` varchar(50) DEFAULT NULL,
`mileage` int(11) DEFAULT NULL,
`departureTime` time DEFAULT NULL,
PRIMARY KEY (`flightID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of flight
-- ----------------------------
INSERT INTO `flight` VALUES ('3U8948', '8', '空客320', '济南', '昆明', '2080', '08:06:00');
INSERT INTO `flight` VALUES ('3U8962', '8', '空客320', '上海', '成都', '2800', '09:06:00');
INSERT INTO `flight` VALUES ('CA1947', '3', '空客340', '上海', '成都', '2800', '12:24:00');
INSERT INTO `flight` VALUES ('CZ3117', '1', '波音738', '武汉', '北京', '1100', '09:20:00');
INSERT INTO `flight` VALUES ('CZ3907', '1', '空客333', '北京', '上海', '1130', '08:36:00');
INSERT INTO `flight` VALUES ('CZ6356', '1', '波音738', '海口', '郑州', '1873', '08:10:00');
INSERT INTO `flight` VALUES ('CZ6553', '1', '空客320', '长春', '上海', '1698', '13:20:00');
INSERT INTO `flight` VALUES ('HO1252', '7', '空客320', '北京', '上海', '1130', '10:40:00');
INSERT INTO `flight` VALUES ('HO1284', '7', '空客320', '长春', '上海', '1698', '15:00:00');
INSERT INTO `flight` VALUES ('HU7188', '4', '波音738', '武汉', '北京', '1100', '14:55:00');
INSERT INTO `flight` VALUES ('HU7291', '4', '波音738', '海口', '郑州', '1873', '11:24:00');
INSERT INTO `flight` VALUES ('HU7309', '4', '波音738', '海口', '郑州', '1873', '17:00:00');
INSERT INTO `flight` VALUES ('MF8069', '6', '波音738', '南宁', '沈阳', '2780', '18:10:00');
INSERT INTO `flight` VALUES ('MF8073', '6', '波音738', '厦门', '沈阳', '2242', '09:15:00');
INSERT INTO `flight` VALUES ('MU2451', '2', '波音738', '武汉', '北京', '1100', '18:39:00');
INSERT INTO `flight` VALUES ('MU2453', '2', '波音738', '武汉', '北京', '1100', '22:45:00');
INSERT INTO `flight` VALUES ('MU2540', '2', '波音738', '上海', '成都', '2800', '23:50:00');
INSERT INTO `flight` VALUES ('MU2885', '2', '空客320', '南京', '西安', '1104', '20:00:00');
INSERT INTO `flight` VALUES ('MU294', '2', '空客320', '上海', '成都', '2800', '19:50:00');
INSERT INTO `flight` VALUES ('MU5102', '2', '空客333', '北京', '上海', '1130', '20:24:00');
INSERT INTO `flight` VALUES ('MU5680', '2', '空客332', '长春', '上海', '1698', '21:56:00');
INSERT INTO `flight` VALUES ('SC1191', '9', '波音738', '济南', '昆明', '2080', '15:45:00');
INSERT INTO `flight` VALUES ('SC4873', '9', '波音738', '济南', '昆明', '2080', '21:17:00');
INSERT INTO `flight` VALUES ('ZH9438', '5', '空客320', '海口', '郑州', '1873', '22:38:00');
INSERT INTO `flight` VALUES ('ZH9516', '5', '空客320', '厦门', '沈阳', '2242', '16:26:00');
INSERT INTO `flight` VALUES ('ZH9602', '5', '空客320', '厦门', '沈阳', '2242', '23:00:00');
-- ----------------------------
-- Table structure for `passenger`
-- ----------------------------
DROP TABLE IF EXISTS `passenger`;
CREATE TABLE `passenger` (
`identityID` varchar(20) NOT NULL,
`name` varchar(50) NOT NULL,
`gender` varchar(4) DEFAULT NULL,
`birthday` date DEFAULT NULL,
`tel` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of passenger
-- ----------------------------
INSERT INTO `passenger` VALUES ('420103198309125344', '刘亚蒙', '男', '1979-07-20', '13565232345');
INSERT INTO `passenger` VALUES ('420103199806195830', '郝琼琼', '女', '1990-08-10', '15334564321');
INSERT INTO `passenger` VALUES ('420104198703125881', '雷亚波', '男', '1985-02-05', '13686035678');
INSERT INTO `passenger` VALUES ('420105197610200916', '魏国兰', '女', '1992-10-19', '13827653456');
INSERT INTO `passenger` VALUES ('420106199208113738', '李慧娟', '女', '1993-05-14', '13967341256');
INSERT INTO `passenger` VALUES ('420107198304262089', '吕兰梦', '女', '1994-11-01', '13878292910');
INSERT INTO `passenger` VALUES ('420211197905122415', '郝嘉志', '男', '1988-04-16', '15945673421');
INSERT INTO `passenger` VALUES ('420506198304161675', '苏彦博', '男', '1991-09-09', '13867236598');
INSERT INTO `passenger` VALUES ('420712197303186681', '严雅可', '女', '1995-03-09', '15367212829');
INSERT INTO `passenger` VALUES ('421009197404104775', '傅明远', '男', '1986-06-06', '13578983521');
-- ----------------------------
-- Table structure for `ticketsell`
-- ----------------------------
DROP TABLE IF EXISTS `ticketsell`;
CREATE TABLE `ticketsell` (
`ordersID` int(11) NOT NULL AUTO_INCREMENT,
`identityID` varchar(20) DEFAULT NULL,
`flightID` varchar(50) DEFAULT NULL,
`flightDate` date DEFAULT NULL,
`grade` varchar(20) DEFAULT NULL,
`seat` varchar(20) DEFAULT NULL,
`price` decimal(10,2) DEFAULT NULL,
`gate` varchar(20) DEFAULT NULL,
PRIMARY KEY (`ordersID`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of ticketsell
-- ----------------------------
INSERT INTO `ticketsell` VALUES ('1', '420103198309125344', '3U8948', '2017-07-11', '经济舱', '8B', '780.00', '3');
INSERT INTO `ticketsell` VALUES ('2', '420103199806195830', 'CZ6356', '2018-08-22', '经济舱', '6E', '1050.00', '2');
INSERT INTO `ticketsell` VALUES ('3', '420104198703125881', 'HO1284', '2019-06-07', '商务舱', '2A', '2680.00', '6');
INSERT INTO `ticketsell` VALUES ('11', '420105197610200916', 'MF8069', '2020-05-09', '经济舱', '12E', '1250.00', '5');
INSERT INTO `ticketsell` VALUES ('12', '420106199208113738', 'MU2540', '2017-02-01', '经济舱', '9C', '760.00', '5');
INSERT INTO `ticketsell` VALUES ('13', '420106199208113738', 'MU5102', '2018-04-12', '商务舱', '3C', '2680.00', '3');
INSERT INTO `ticketsell` VALUES ('14', '420105197610200916', 'SC4873', '2019-09-21', '经济舱', '10F', '890.00', '4');
INSERT INTO `ticketsell` VALUES ('15', '420104198703125881', 'ZH9516', '2020-10-30', '商务舱', '2B', '2880.00', '4');
INSERT INTO `ticketsell` VALUES ('16', '420103199806195830', 'ZH9438', '2021-11-11', '经济舱', '13D', '890.00', '2');
INSERT INTO `ticketsell` VALUES ('17', '420103198309125344', 'MU5680', '2022-01-09', '经济舱', '7B', '920.00', '5');
INSERT INTO `ticketsell` VALUES ('18', '420103199806195830', 'MU2451', '2017-01-28', '经济舱', '9C', '460.00', '3');
INSERT INTO `ticketsell` VALUES ('19', '420106199208113738', 'MU2885', '2018-02-24', '经济舱', '8D', '620.00', '3');
INSERT INTO `ticketsell` VALUES ('20', '420105197610200916', 'HU7188', '2019-11-04', '经济舱', '13C', '560.00', '2');
INSERT INTO `ticketsell` VALUES ('21', '420103198309125344', 'MF8073', '2020-12-15', '经济舱', '5E', '1050.00', '5');
INSERT INTO `ticketsell` VALUES ('22', '420104198703125881', 'MU5102', '2021-09-19', '商务舱', '4B', '2880.00', '3');
INSERT INTO `ticketsell` VALUES ('23', '420104198703125881', 'HU7188', '2022-02-23', '经济舱', '8C', '560.00', '3');
INSERT INTO `ticketsell` VALUES ('24', '420103198309125344', 'HU7188', '2017-10-17', '经济舱', '9A', '560.00', '3');
INSERT INTO `ticketsell` VALUES ('25', '420104198703125881', 'MU2451', '2018-07-29', '经济舱', '6C', '460.00', '3');
INSERT INTO `ticketsell` VALUES ('26', '420105197610200916', 'MU2451', '2019-09-09', '经济舱', '6B', '460.00', '3');
INSERT INTO `ticketsell` VALUES ('27', '420103198309125344', 'MU2451', '2020-08-15', '经济舱', '5F', '460.00', '3');
INSERT INTO `ticketsell` VALUES ('28', '420106199208113738', 'CZ3117', '2021-06-29', '经济舱', '15C', '510.00', '5');
INSERT INTO `ticketsell` VALUES ('29', '420104198703125881', 'CZ3117', '2022-03-31', '经济舱', '12A', '510.00', '5');
INSERT INTO `ticketsell` VALUES ('30', '420103199806195830', 'MU2453', '2017-05-07', '经济舱', '7E', '420.00', '4');
INSERT INTO `ticketsell` VALUES ('31', '420103198309125344', 'MU2453', '2018-06-20', '经济舱', '8C', '420.00', '4');
INSERT INTO `ticketsell` VALUES ('32', '420103199806195830', 'HU7188', '2019-10-05', '头等舱', '1B', '2320.00', '3');
INSERT INTO `ticketsell` VALUES ('33', '420106199208113738', 'HU7188', '2020-11-23', '商务舱', '4A', '1730.00', '3');
INSERT INTO `ticketsell` VALUES ('34', '420211197905122415', 'MU2451', '2021-02-12', '经济舱', '8C', '470.00', '6');
INSERT INTO `ticketsell` VALUES ('35', '420506198304161675', 'MU2451', '2022-04-21', '经济舱', '13D', '470.00', '6');
INSERT INTO `ticketsell` VALUES ('36', '420107198304262089', 'CZ3117', '2017-06-28', '经济舱', '15E', '430.00', '3');
INSERT INTO `ticketsell` VALUES ('37', '420712197303186681', 'MU2453', '2019-07-10', '经济舱', '6F', '590.00', '4');
INSERT INTO `ticketsell` VALUES ('38', '421009197404104775', 'MU2453', '2021-08-26', '经济舱', '8A', '590.00', '4');