代码 · 大模型全阶段学习中心

insert  into travel_rag.weather_data(`id`,`city`,`fx_date`,`sunrise`,`sunset`,`moonrise`,`moonset`,`moon_phase`,`moon_phase_icon`,`temp_max`,`temp_min`,`icon_day`,`text_day`,`icon_night`,`text_night`,`wind360_day`,`wind_dir_day`,`wind_scale_day`,`wind_speed_day`,`wind360_night`,`wind_dir_night`,`wind_scale_night`,`wind_speed_night`,`precip`,`uv_index`,`humidity`,`pressure`,`vis`,`cloud`,`update_time`) values (241,'北京','2025-07-28','05:10:00','19:33:00','08:36:00','21:34:00','蛾眉月','801',30,25,'302','雷阵雨','307','大雨',225,'西南风','1-3',3,270,'西风','1-3',3,'2.1',8,89,992,20,40,'2025-07-28 14:52:00'),(242,'北京','2025-07-29','05:11:00','19:33:00','09:39:00','21:54:00','蛾眉月','801',33,24,'302','雷阵雨','151','多云',270,'西风','1-3',3,45,'东北风','1-3',3,'7.8',5,85,994,24,48,'2025-07-28 14:52:00'),(243,'北京','2025-07-30','05:11:00','19:32:00','10:40:00','22:13:00','蛾眉月','801',32,24,'101','多云','104','阴',90,'东风','1-3',3,45,'东北风','1-3',3,'1.0',10,83,995,24,40,'2025-07-28 14:52:00'),(244,'北京','2025-07-31','05:12:00','19:31:00','11:40:00','22:34:00','蛾眉月','801',30,24,'101','多云','151','多云',135,'东南风','1-3',3,45,'东北风','1-3',3,'1.0',5,88,996,24,40,'2025-07-28 14:52:00'),(245,'北京','2025-08-01','05:13:00','19:30:00','12:41:00','22:58:00','上弦月','802',30,24,'104','阴','104','阴',180,'南风','1-3',3,135,'东南风','1-3',3,'0.0',9,69,995,24,25,'2025-07-28 14:52:00'),(246,'北京','2025-08-02','05:14:00','19:29:00','13:43:00','23:24:00','盈凸月','803',32,24,'302','雷阵雨','151','多云',135,'东南风','1-3',3,135,'东南风','1-3',3,'0.0',9,72,992,22,2,'2025-07-28 14:52:00'),(247,'北京','2025-08-03','05:15:00','19:27:00','14:45:00','23:59:00','盈凸月','803',32,24,'101','多云','302','雷阵雨',225,'西南风','1-3',3,0,'北风','1-3',3,'0.3',5,80,995,24,40,'2025-07-28 14:52:00'),(248,'北京','2025-08-04','05:16:00','19:26:00','15:46:00','00:00:00','盈凸月','803',32,23,'305','小雨','104','阴',135,'东南风','1-3',3,45,'东北风','1-3',3,'16.7',9,90,993,20,85,'2025-07-28 14:52:00'),(249,'北京','2025-08-05','05:17:00','19:25:00','16:43:00','00:40:00','盈凸月','803',32,24,'101','多云','150','晴',180,'南风','1-3',3,45,'东北风','1-3',3,'0.0',9,91,993,25,1,'2025-07-28 14:52:00'),(250,'北京','2025-08-06','05:18:00','19:24:00','17:34:00','01:29:00','盈凸月','803',34,25,'104','阴','104','阴',180,'南风','1-3',3,90,'东风','1-3',3,'0.0',9,76,997,24,0,'2025-07-28 14:52:00'),(251,'北京','2025-08-07','05:19:00','19:23:00','18:18:00','02:28:00','盈凸月','803',33,20,'305','小雨','305','小雨',270,'西风','1-3',3,315,'西北风','1-3',3,'0.0',5,82,1000,23,10,'2025-07-28 14:52:00'),(252,'北京','2025-08-08','05:20:00','19:22:00','18:55:00','03:34:00','盈凸月','803',31,18,'101','多云','151','多云',0,'北风','1-3',3,0,'北风','1-3',3,'0.0',9,89,1000,22,15,'2025-07-28 14:52:00'),(253,'北京','2025-08-09','05:21:00','19:21:00','19:26:00','04:44:00','满月','804',30,18,'104','阴','150','晴',0,'北风','1-3',3,0,'北风','1-3',3,'0.6',9,85,999,24,56,'2025-07-28 14:52:00'),(254,'北京','2025-08-10','05:22:00','19:19:00','19:54:00','05:55:00','亏凸月','805',34,20,'101','多云','104','阴',225,'西南风','1-3',3,225,'西南风','1-3',3,'0.0',8,72,997,25,20,'2025-07-28 14:52:00'),(255,'北京','2025-08-11','05:23:00','19:18:00','20:19:00','07:06:00','亏凸月','805',33,24,'101','多云','302','雷阵雨',180,'南风','1-3',3,180,'南风','1-3',3,'0.0',9,88,999,24,6,'2025-08-11 20:18:00'),(256,'北京','2025-08-12','05:24:00','19:17:00','20:44:00','08:17:00','亏凸月','805',31,22,'302','雷阵雨','306','中雨',90,'东风','1-3',3,0,'北风','1-3',3,'5.0',5,94,1003,24,80,'2025-08-11 20:18:00'),(257,'北京','2025-08-13','05:25:00','19:16:00','21:08:00','09:29:00','亏凸月','805',31,23,'302','雷阵雨','151','多云',225,'西南风','1-3',3,0,'北风','1-3',3,'0.0',3,94,1005,24,25,'2025-08-11 20:18:00'),(258,'北京','2025-08-14','05:26:00','19:14:00','21:36:00','10:44:00','亏凸月','805',31,23,'104','阴','302','雷阵雨',180,'南风','1-3',3,135,'东南风','1-3',3,'0.0',9,95,1005,19,25,'2025-08-11 20:18:00'),(259,'北京','2025-08-15','05:27:00','19:13:00','22:07:00','12:02:00','亏凸月','805',31,23,'101','多云','302','雷阵雨',180,'南风','1-3',3,135,'东南风','1-3',3,'0.0',5,91,1002,24,14,'2025-08-11 20:18:00'),(260,'北京','2025-08-16','05:28:00','19:12:00','22:46:00','13:19:00','下弦月','806',31,24,'302','雷阵雨','302','雷阵雨',180,'南风','1-3',3,180,'南风','1-3',3,'4.9',3,92,1002,23,88,'2025-08-11 20:18:00'),(261,'北京','2025-08-17','05:29:00','19:10:00','23:34:00','14:37:00','残月','807',31,24,'302','雷阵雨','104','阴',180,'南风','1-3',3,180,'南风','1-3',3,'1.0',2,95,998,22,55,'2025-08-11 20:18:00'),(262,'北京','2025-08-18','05:30:00','19:09:00','00:00:00','15:50:00','残月','807',30,24,'104','阴','305','小雨',180,'南风','1-3',3,0,'北风','1-3',3,'2.5',2,90,998,25,55,'2025-08-11 20:18:00'),(263,'北京','2025-08-19','05:31:00','19:08:00','00:33:00','16:52:00','残月','807',31,23,'104','阴','305','小雨',90,'东风','1-3',3,0,'北风','1-3',3,'4.6',2,97,996,7,55,'2025-08-11 20:18:00'),(264,'北京','2025-08-20','05:31:00','19:06:00','01:40:00','17:41:00','残月','807',31,23,'305','小雨','305','小雨',45,'东北风','1-3',3,45,'东北风','1-3',3,'0.0',4,97,996,12,10,'2025-08-11 20:18:00'),(265,'北京','2025-08-21','05:32:00','19:05:00','02:53:00','18:19:00','残月','807',28,23,'305','小雨','305','小雨',180,'南风','1-3',3,0,'北风','1-3',3,'22.4',1,81,1005,24,80,'2025-08-11 20:18:00'),(266,'北京','2025-08-22','05:33:00','19:03:00','04:05:00','18:51:00','残月','807',29,19,'104','阴','104','阴',45,'东北风','1-3',16,135,'东南风','1-3',3,'0.0',8,77,1009,24,2,'2025-08-11 20:18:00'),(267,'北京','2025-08-23','05:34:00','19:02:00','05:16:00','19:16:00','新月','800',26,19,'101','多云','104','阴',180,'南风','1-3',3,180,'南风','1-3',3,'5.9',4,90,1008,20,65,'2025-08-11 20:18:00'),(268,'北京','2025-08-24','05:35:00','19:00:00','06:23:00','19:38:00','蛾眉月','801',28,21,'104','阴','305','小雨',180,'南风','1-3',3,0,'北风','1-3',3,'0.6',2,92,1006,16,56,'2025-08-11 20:18:00'),(269,'北京','2025-08-25','05:36:00','18:59:00','07:27:00','19:59:00','蛾眉月','801',23,20,'305','小雨','104','阴',0,'北风','1-3',3,0,'北风','1-3',3,'1.4',2,99,1000,12,55,'2025-08-11 20:18:00'),(270,'北京','2025-08-26','05:37:00','18:57:00','08:29:00','20:17:00','蛾眉月','801',27,21,'302','雷阵雨','302','雷阵雨',122,'东南风','1-3',7,145,'东南风','1-3',11,'11.2',2,91,1003,24,69,'2025-08-11 20:18:00'),(271,'上海','2025-07-28','05:09:00','18:54:00','08:21:00','21:10:00','蛾眉月','801',31,25,'305','小雨','305','小雨',90,'东风','1-3',16,90,'东风','1-3',3,'3.8',5,80,999,24,78,'2025-07-28 14:52:00'),(272,'上海','2025-07-29','05:09:00','18:53:00','09:18:00','21:35:00','蛾眉月','801',29,26,'310','暴雨','306','中雨',135,'东南风','1-3',16,90,'东风','1-3',16,'28.0',3,95,995,4,98,'2025-07-28 14:52:00'),(273,'上海','2025-07-30','05:10:00','18:52:00','10:13:00','22:01:00','蛾眉月','801',29,26,'307','大雨','307','大雨',135,'东南风','1-3',16,135,'东南风','1-3',16,'10.4',6,95,990,12,87,'2025-07-28 14:52:00'),(274,'上海','2025-07-31','05:11:00','18:52:00','11:08:00','22:26:00','蛾眉月','801',31,27,'305','小雨','305','小雨',135,'东南风','1-3',16,135,'东南风','1-3',16,'1.0',11,93,996,24,40,'2025-07-28 14:52:00'),(275,'上海','2025-08-01','05:11:00','18:51:00','12:03:00','22:56:00','上弦月','802',32,28,'305','小雨','104','阴',135,'东南风','1-3',16,135,'东南风','1-3',16,'0.7',9,96,996,23,56,'2025-07-28 14:52:00'),(276,'上海','2025-08-02','05:12:00','18:50:00','12:59:00','23:27:00','盈凸月','803',32,27,'305','小雨','305','小雨',135,'东南风','1-3',16,90,'东风','1-3',3,'2.5',5,91,998,24,41,'2025-07-28 14:52:00'),(277,'上海','2025-08-03','05:13:00','18:50:00','13:57:00','00:00:00','盈凸月','803',33,28,'104','阴','151','多云',135,'东南风','1-3',3,0,'北风','1-3',3,'2.4',8,84,1001,25,43,'2025-07-28 14:52:00'),(278,'上海','2025-08-04','05:13:00','18:49:00','14:54:00','00:05:00','盈凸月','803',34,28,'305','小雨','151','多云',135,'东南风','1-3',3,180,'南风','1-3',3,'0.0',8,81,1001,24,25,'2025-07-28 14:52:00'),(279,'上海','2025-08-05','05:14:00','18:48:00','15:50:00','00:50:00','盈凸月','803',35,28,'100','晴','104','阴',135,'东南风','1-3',3,225,'西南风','1-3',3,'1.8',8,83,1000,25,63,'2025-07-28 14:52:00'),(280,'上海','2025-08-06','05:15:00','18:47:00','16:42:00','01:40:00','盈凸月','803',35,29,'305','小雨','104','阴',180,'南风','1-3',3,90,'东风','1-3',3,'8.5',7,89,1001,24,64,'2025-07-28 14:52:00'),(281,'上海','2025-08-07','05:15:00','18:46:00','17:29:00','02:38:00','盈凸月','803',35,28,'104','阴','104','阴',90,'东风','1-3',3,90,'东风','1-3',3,'8.5',5,91,1001,24,64,'2025-07-28 14:52:00'),(282,'上海','2025-08-08','05:16:00','18:45:00','18:11:00','03:39:00','盈凸月','803',38,29,'104','阴','104','阴',45,'东北风','1-3',3,90,'东风','1-3',3,'7.3',5,95,999,24,61,'2025-07-28 14:52:00'),(283,'上海','2025-08-09','05:17:00','18:44:00','18:48:00','04:44:00','满月','804',37,28,'305','小雨','305','小雨',90,'东风','1-3',3,0,'北风','1-3',3,'0.0',4,95,996,23,25,'2025-07-28 14:52:00'),(284,'上海','2025-08-10','05:17:00','18:44:00','19:22:00','05:49:00','亏凸月','805',33,28,'305','小雨','305','小雨',0,'北风','1-3',3,270,'西风','1-3',3,'12.1',3,96,997,15,65,'2025-07-28 14:52:00'),(285,'上海','2025-08-11','05:18:00','18:43:00','19:53:00','06:54:00','亏凸月','805',35,27,'305','小雨','305','小雨',45,'东北风','1-3',3,90,'东风','1-3',3,'4.1',7,94,1005,24,55,'2025-08-11 20:18:00'),(286,'上海','2025-08-12','05:18:00','18:42:00','20:24:00','07:59:00','亏凸月','805',35,28,'305','小雨','104','阴',180,'南风','1-3',3,180,'南风','1-3',3,'3.3',3,82,1008,24,88,'2025-08-11 20:18:00'),(287,'上海','2025-08-13','05:19:00','18:41:00','20:55:00','09:04:00','亏凸月','805',35,28,'104','阴','104','阴',180,'南风','1-3',3,180,'南风','1-3',16,'0.0',11,83,1011,25,5,'2025-08-11 20:18:00'),(288,'上海','2025-08-14','05:20:00','18:40:00','21:29:00','10:11:00','亏凸月','805',35,28,'104','阴','104','阴',135,'东南风','1-3',16,180,'南风','1-3',16,'0.0',9,82,1011,25,4,'2025-08-11 20:18:00'),(289,'上海','2025-08-15','05:20:00','18:39:00','22:07:00','11:21:00','亏凸月','805',35,27,'101','多云','104','阴',135,'东南风','1-3',16,135,'东南风','1-3',3,'0.0',11,82,1011,25,2,'2025-08-11 20:18:00'),(290,'上海','2025-08-16','05:21:00','18:38:00','22:52:00','12:33:00','下弦月','806',35,27,'104','阴','104','阴',135,'东南风','1-3',16,135,'东南风','1-3',3,'0.0',11,85,1011,25,2,'2025-08-11 20:18:00'),(291,'上海','2025-08-17','05:22:00','18:37:00','23:44:00','13:46:00','残月','807',35,27,'104','阴','104','阴',135,'东南风','1-3',3,180,'南风','1-3',3,'0.0',10,83,1009,25,3,'2025-08-11 20:18:00'),(292,'上海','2025-08-18','05:22:00','18:36:00','00:00:00','14:56:00','残月','807',36,28,'104','阴','150','晴',135,'东南风','1-3',3,180,'南风','1-3',3,'0.0',10,83,1008,25,3,'2025-08-11 20:18:00'),(293,'上海','2025-08-19','05:23:00','18:35:00','00:44:00','15:59:00','残月','807',35,27,'101','多云','150','晴',135,'东南风','1-3',16,135,'东南风','1-3',3,'0.0',10,82,1005,25,2,'2025-08-11 20:18:00'),(294,'上海','2025-08-20','05:24:00','18:34:00','01:50:00','16:52:00','残月','807',35,27,'100','晴','150','晴',135,'东南风','1-3',16,135,'东南风','1-3',3,'0.3',10,72,1004,25,55,'2025-08-11 20:18:00'),(295,'上海','2025-08-21','05:24:00','18:32:00','02:58:00','17:35:00','残月','807',34,27,'100','晴','151','多云',135,'东南风','3-4',24,135,'东南风','1-3',16,'0.0',10,77,1007,25,1,'2025-08-11 20:18:00'),(296,'上海','2025-08-22','05:25:00','18:31:00','04:06:00','18:12:00','残月','807',34,28,'101','多云','151','多云',135,'东南风','3-4',24,135,'东南风','1-3',16,'0.0',10,75,1009,25,1,'2025-08-11 20:18:00'),(297,'上海','2025-08-23','05:25:00','18:30:00','05:10:00','18:44:00','新月','800',34,27,'101','多云','151','多云',135,'东南风','1-3',16,135,'东南风','1-3',16,'0.0',6,81,1011,25,25,'2025-08-11 20:18:00'),(298,'上海','2025-08-24','05:26:00','18:29:00','06:11:00','19:12:00','蛾眉月','801',34,27,'101','多云','151','多云',135,'东南风','1-3',16,135,'东南风','1-3',16,'3.2',10,83,1011,25,65,'2025-08-11 20:18:00'),(299,'上海','2025-08-25','05:27:00','18:28:00','07:08:00','19:38:00','蛾眉月','801',35,26,'100','晴','150','晴',135,'东南风','1-3',16,135,'东南风','1-3',16,'2.2',4,83,1008,25,65,'2025-08-11 20:18:00'),(300,'上海','2025-08-26','05:27:00','18:27:00','08:04:00','20:03:00','蛾眉月','801',31,25,'302','雷阵雨','350','阵雨',131,'东南风','3-4',26,132,'东南风','3-4',24,'2.9',5,81,1008,25,65,'2025-08-11 20:18:00'),(301,'广州','2025-07-28','05:56:00','19:12:00','09:00:00','21:41:00','蛾眉月','801',35,25,'315','中到大雨','315','中到大雨',0,'北风','1-3',3,0,'北风','1-3',3,'15.1',5,81,994,24,92,'2025-07-28 14:52:00'),(302,'广州','2025-07-29','05:57:00','19:11:00','09:52:00','22:10:00','蛾眉月','801',33,25,'315','中到大雨','302','雷阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'5.9',4,78,994,21,78,'2025-07-28 14:52:00'),(303,'广州','2025-07-30','05:57:00','19:11:00','10:43:00','22:40:00','蛾眉月','801',33,26,'302','雷阵雨','302','雷阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'12.0',3,77,994,22,88,'2025-07-28 14:52:00'),(304,'广州','2025-07-31','05:58:00','19:10:00','11:34:00','23:10:00','蛾眉月','801',34,26,'302','雷阵雨','302','雷阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'8.9',12,74,996,24,76,'2025-07-28 14:52:00'),(305,'广州','2025-08-01','05:58:00','19:10:00','12:25:00','23:43:00','上弦月','802',34,26,'302','雷阵雨','302','雷阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'4.2',3,77,997,19,71,'2025-07-28 14:52:00'),(306,'广州','2025-08-02','05:58:00','19:09:00','13:17:00','00:00:00','盈凸月','803',33,25,'302','雷阵雨','302','雷阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'4.5',3,82,999,18,60,'2025-07-28 14:52:00'),(307,'广州','2025-08-03','05:59:00','19:09:00','14:11:00','00:19:00','盈凸月','803',30,26,'307','大雨','307','大雨',0,'北风','1-3',3,0,'北风','1-3',3,'24.1',3,83,1002,21,69,'2025-07-28 14:52:00'),(308,'广州','2025-08-04','05:59:00','19:08:00','15:05:00','01:01:00','盈凸月','803',29,25,'305','小雨','305','小雨',180,'南风','1-3',3,225,'西南风','1-3',3,'21.7',4,73,1002,24,68,'2025-07-28 14:52:00'),(309,'广州','2025-08-05','06:00:00','19:08:00','15:59:00','01:47:00','盈凸月','803',31,26,'305','小雨','305','小雨',90,'东风','1-3',3,180,'南风','1-3',3,'9.8',3,68,1001,25,64,'2025-07-28 14:52:00'),(310,'广州','2025-08-06','06:00:00','19:07:00','16:52:00','02:39:00','盈凸月','803',32,27,'305','小雨','305','小雨',135,'东南风','1-3',3,180,'南风','1-3',3,'1.6',11,70,1001,25,56,'2025-07-28 14:52:00'),(311,'广州','2025-08-07','06:01:00','19:06:00','17:42:00','03:34:00','盈凸月','803',33,27,'305','小雨','104','阴',180,'南风','1-3',3,180,'南风','1-3',3,'1.8',5,71,1002,25,57,'2025-07-28 14:52:00'),(312,'广州','2025-08-08','06:01:00','19:06:00','18:27:00','04:34:00','盈凸月','803',32,27,'104','阴','104','阴',135,'东南风','1-3',3,180,'南风','1-3',3,'2.0',6,71,1000,24,40,'2025-07-28 14:52:00'),(313,'广州','2025-08-09','06:01:00','19:05:00','19:08:00','05:34:00','满月','804',33,27,'305','小雨','305','小雨',225,'西南风','1-3',3,180,'南风','1-3',3,'0.0',5,73,998,22,25,'2025-07-28 14:52:00'),(314,'广州','2025-08-10','06:02:00','19:04:00','19:46:00','06:35:00','亏凸月','805',34,27,'305','小雨','305','小雨',270,'西风','1-3',3,180,'南风','1-3',3,'0.0',4,73,998,23,25,'2025-07-28 14:52:00'),(315,'广州','2025-08-11','06:02:00','19:04:00','20:23:00','07:34:00','亏凸月','805',35,26,'101','多云','350','阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'3.7',6,71,1004,24,80,'2025-08-11 20:18:00'),(316,'广州','2025-08-12','06:03:00','19:03:00','20:58:00','08:34:00','亏凸月','805',35,26,'302','雷阵雨','350','阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'8.4',6,76,1005,24,89,'2025-08-11 20:18:00'),(317,'广州','2025-08-13','06:03:00','19:02:00','21:35:00','09:34:00','亏凸月','805',35,24,'302','雷阵雨','302','雷阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'2.0',12,77,1001,22,80,'2025-08-11 20:18:00'),(318,'广州','2025-08-14','06:04:00','19:02:00','22:14:00','10:37:00','亏凸月','805',29,24,'307','大雨','307','大雨',180,'南风','1-3',16,0,'北风','1-3',3,'15.1',4,89,1005,16,95,'2025-08-11 20:18:00'),(319,'广州','2025-08-15','06:04:00','19:01:00','22:57:00','11:42:00','亏凸月','805',31,24,'307','大雨','302','雷阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'7.6',3,82,1007,24,75,'2025-08-11 20:18:00'),(320,'广州','2025-08-16','06:04:00','19:00:00','23:46:00','12:49:00','下弦月','806',33,26,'302','雷阵雨','302','雷阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'0.7',8,68,1006,24,62,'2025-08-11 20:18:00'),(321,'广州','2025-08-17','06:05:00','18:59:00','00:00:00','13:58:00','残月','807',34,26,'302','雷阵雨','302','雷阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'0.0',11,67,1006,24,25,'2025-08-11 20:18:00'),(322,'广州','2025-08-18','06:05:00','18:58:00','00:42:00','15:06:00','残月','807',34,24,'305','小雨','151','多云',0,'北风','1-3',3,45,'东北风','1-3',3,'2.9',7,66,1002,24,70,'2025-08-11 20:18:00'),(323,'广州','2025-08-19','06:05:00','18:58:00','01:43:00','16:08:00','残月','807',28,24,'305','小雨','305','小雨',90,'东风','1-3',3,90,'东风','1-3',3,'8.3',4,85,1002,10,62,'2025-08-11 20:18:00'),(324,'广州','2025-08-20','06:06:00','18:57:00','02:48:00','17:04:00','残月','807',28,24,'305','小雨','305','小雨',180,'南风','1-3',3,90,'东风','1-3',3,'2.0',6,89,1002,13,55,'2025-08-11 20:18:00'),(325,'广州','2025-08-21','06:06:00','18:56:00','03:53:00','17:52:00','残月','807',26,24,'305','小雨','305','小雨',180,'南风','1-3',3,135,'东南风','1-3',3,'0.7',11,91,1003,13,56,'2025-08-11 20:18:00'),(326,'广州','2025-08-22','06:07:00','18:55:00','04:56:00','18:33:00','残月','807',27,23,'305','小雨','305','小雨',180,'南风','1-3',3,180,'南风','1-3',3,'2.9',10,91,1004,17,75,'2025-08-11 20:18:00'),(327,'广州','2025-08-23','06:07:00','18:54:00','05:56:00','19:09:00','新月','800',23,22,'305','小雨','305','小雨',135,'东南风','1-3',3,45,'东北风','1-3',3,'1.4',3,92,1005,24,62,'2025-08-11 20:18:00'),(328,'广州','2025-08-24','06:07:00','18:53:00','06:52:00','19:41:00','蛾眉月','801',24,22,'305','小雨','305','小雨',45,'东北风','1-3',3,45,'东北风','1-3',3,'0.0',11,91,1004,24,20,'2025-08-11 20:18:00'),(329,'广州','2025-08-25','06:08:00','18:53:00','07:45:00','20:11:00','蛾眉月','801',25,22,'305','小雨','305','小雨',90,'东风','1-3',3,45,'东北风','1-3',3,'0.0',11,77,1003,24,25,'2025-08-11 20:18:00'),(330,'广州','2025-08-26','06:08:00','18:52:00','08:37:00','20:41:00','蛾眉月','801',33,25,'101','多云','153','晴间多云',52,'东北风','1-3',13,78,'东北风','1-3',6,'5.3',4,71,1003,24,58,'2025-08-11 20:18:00'),(331,'深圳','2025-07-28','05:54:00','19:08:00','08:57:00','21:37:00','蛾眉月','801',32,26,'300','阵雨','350','阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'14.2',5,84,987,24,90,'2025-07-28 14:52:00'),(332,'深圳','2025-07-29','05:54:00','19:07:00','09:49:00','22:07:00','蛾眉月','801',32,26,'306','中雨','307','大雨',0,'北风','1-3',3,0,'北风','1-3',3,'10.9',3,84,987,24,94,'2025-07-28 14:52:00'),(333,'深圳','2025-07-30','05:55:00','19:07:00','10:40:00','22:37:00','蛾眉月','801',32,26,'307','大雨','350','阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'22.5',3,88,988,24,97,'2025-07-28 14:52:00'),(334,'深圳','2025-07-31','05:55:00','19:06:00','11:30:00','23:08:00','蛾眉月','801',30,26,'300','阵雨','350','阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'3.8',6,87,990,24,70,'2025-07-28 14:52:00'),(335,'深圳','2025-08-01','05:56:00','19:06:00','12:20:00','23:41:00','上弦月','802',32,27,'300','阵雨','151','多云',0,'北风','1-3',3,0,'北风','1-3',3,'9.7',11,87,991,21,84,'2025-07-28 14:52:00'),(336,'深圳','2025-08-02','05:56:00','19:05:00','13:12:00','00:00:00','盈凸月','803',32,27,'300','阵雨','350','阵雨',0,'北风','1-3',3,225,'西南风','1-3',16,'21.2',5,84,993,24,74,'2025-07-28 14:52:00'),(337,'深圳','2025-08-03','05:57:00','19:05:00','14:06:00','00:17:00','盈凸月','803',30,26,'104','阴','310','暴雨',0,'北风','1-3',3,0,'北风','1-3',3,'26.1',4,83,995,23,70,'2025-07-28 14:52:00'),(338,'深圳','2025-08-04','05:57:00','19:04:00','15:00:00','00:59:00','盈凸月','803',30,27,'305','小雨','305','小雨',180,'南风','1-3',3,225,'西南风','1-3',3,'21.5',2,86,996,24,72,'2025-07-28 14:52:00'),(339,'深圳','2025-08-05','05:57:00','19:03:00','15:55:00','01:45:00','盈凸月','803',30,27,'305','小雨','305','小雨',180,'南风','1-3',3,225,'西南风','1-3',3,'15.2',3,87,995,25,72,'2025-07-28 14:52:00'),(340,'深圳','2025-08-06','05:58:00','19:03:00','16:48:00','02:37:00','盈凸月','803',30,28,'305','小雨','305','小雨',180,'南风','1-3',3,180,'南风','1-3',3,'2.2',7,87,995,22,55,'2025-07-28 14:52:00'),(341,'深圳','2025-08-07','05:58:00','19:02:00','17:37:00','03:33:00','盈凸月','803',31,28,'305','小雨','305','小雨',180,'南风','1-3',16,180,'南风','1-3',3,'0.4',5,87,996,24,43,'2025-07-28 14:52:00'),(342,'深圳','2025-08-08','05:59:00','19:02:00','18:22:00','04:32:00','盈凸月','803',31,28,'305','小雨','305','小雨',180,'南风','1-3',3,225,'西南风','1-3',3,'0.3',6,87,994,24,41,'2025-07-28 14:52:00'),(343,'深圳','2025-08-09','05:59:00','19:01:00','19:03:00','05:32:00','满月','804',30,27,'305','小雨','305','小雨',225,'西南风','1-3',16,225,'西南风','1-3',3,'0.0',3,88,992,22,25,'2025-07-28 14:52:00'),(344,'深圳','2025-08-10','05:59:00','19:00:00','19:43:00','06:32:00','亏凸月','805',30,27,'305','小雨','305','小雨',225,'西南风','1-3',16,180,'南风','1-3',3,'0.0',3,83,992,18,25,'2025-07-28 14:52:00'),(345,'深圳','2025-08-11','06:00:00','19:00:00','20:19:00','07:31:00','亏凸月','805',33,27,'300','阵雨','350','阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'10.1',6,86,997,23,100,'2025-08-11 20:18:00'),(346,'深圳','2025-08-12','06:00:00','18:59:00','20:55:00','08:31:00','亏凸月','805',33,27,'300','阵雨','150','晴',0,'北风','1-3',3,0,'北风','1-3',3,'7.6',5,86,999,24,75,'2025-08-11 20:18:00'),(347,'深圳','2025-08-13','06:01:00','18:58:00','21:32:00','09:31:00','亏凸月','805',33,27,'300','阵雨','350','阵雨',0,'北风','1-3',3,225,'西南风','1-3',16,'6.0',7,83,995,22,69,'2025-08-11 20:18:00'),(348,'深圳','2025-08-14','06:01:00','18:58:00','22:11:00','10:33:00','亏凸月','805',30,26,'300','阵雨','350','阵雨',225,'西南风','1-3',16,0,'北风','1-3',3,'17.3',2,83,999,24,96,'2025-08-11 20:18:00'),(349,'深圳','2025-08-15','06:01:00','18:57:00','22:55:00','11:37:00','亏凸月','805',31,26,'300','阵雨','350','阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'4.8',3,81,1000,24,74,'2025-08-11 20:18:00'),(350,'深圳','2025-08-16','06:02:00','18:56:00','23:44:00','12:45:00','下弦月','806',33,27,'300','阵雨','350','阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'1.5',9,80,1000,25,68,'2025-08-11 20:18:00'),(351,'深圳','2025-08-17','06:02:00','18:55:00','00:00:00','13:53:00','残月','807',32,26,'300','阵雨','350','阵雨',0,'北风','1-3',3,0,'北风','1-3',3,'2.1',12,82,999,24,61,'2025-08-11 20:18:00'),(352,'深圳','2025-08-18','06:03:00','18:55:00','00:40:00','15:01:00','残月','807',31,25,'305','小雨','305','小雨',0,'北风','1-3',3,90,'东风','1-3',3,'6.7',4,80,995,20,62,'2025-08-11 20:18:00'),(353,'深圳','2025-08-19','06:03:00','18:54:00','01:41:00','16:03:00','残月','807',29,26,'305','小雨','305','小雨',90,'东风','1-3',3,90,'东风','1-3',3,'3.1',3,93,996,7,62,'2025-08-11 20:18:00'),(354,'深圳','2025-08-20','06:03:00','18:53:00','02:46:00','16:59:00','残月','807',28,25,'305','小雨','305','小雨',90,'东风','1-3',3,90,'东风','1-3',3,'1.3',10,92,996,9,59,'2025-08-11 20:18:00'),(355,'深圳','2025-08-21','06:04:00','18:52:00','03:51:00','17:47:00','残月','807',27,25,'305','小雨','305','小雨',180,'南风','1-3',3,225,'西南风','1-3',3,'0.5',12,92,997,18,55,'2025-08-11 20:18:00'),(356,'深圳','2025-08-22','06:04:00','18:51:00','04:54:00','18:28:00','残月','807',26,24,'305','小雨','305','小雨',180,'南风','1-3',3,135,'东南风','1-3',3,'0.4',10,90,998,20,55,'2025-08-11 20:18:00'),(357,'深圳','2025-08-23','06:04:00','18:50:00','05:53:00','19:05:00','新月','800',25,23,'305','小雨','305','小雨',180,'南风','1-3',3,45,'东北风','1-3',3,'1.0',11,94,997,13,41,'2025-08-11 20:18:00'),(358,'深圳','2025-08-24','06:05:00','18:50:00','06:49:00','19:37:00','蛾眉月','801',25,23,'305','小雨','305','小雨',45,'东北风','1-3',16,90,'东风','3-4',24,'0.7',11,88,996,24,41,'2025-08-11 20:18:00'),(359,'深圳','2025-08-25','06:05:00','18:49:00','07:42:00','20:08:00','蛾眉月','801',25,23,'305','小雨','305','小雨',90,'东风','3-4',24,90,'东风','1-3',16,'1.3',11,77,995,24,61,'2025-08-11 20:18:00'),(360,'深圳','2025-08-26','06:05:00','18:48:00','08:33:00','20:38:00','蛾眉月','801',33,27,'103','晴间多云','151','多云',55,'东北风','1-3',7,98,'东风','1-3',15,'2.5',5,81,996,22,57,'2025-08-11 20:18:00'),(377,'北京','2025-08-27','05:38:00','18:56:00','09:30:00','20:38:00','蛾眉月','801',28,21,'302','雷阵雨','350','阵雨',235,'西南风','1-3',6,217,'西南风','1-3',7,'6.3',2,67,1005,25,65,'2025-08-11 20:18:00'),(378,'北京','2025-08-28','05:39:00','18:54:00','10:31:00','21:01:00','蛾眉月','801',30,21,'101','多云','151','多云',45,'东北风','1-3',7,342,'西北风','1-3',9,'0.0',3,90,1003,19,25,'2025-08-11 20:18:00'),(379,'北京','2025-08-29','05:40:00','18:53:00','11:33:00','21:26:00','蛾眉月','801',26,18,'305','小雨','305','小雨',353,'北风','1-3',15,165,'东南风','1-3',11,'10.3',2,89,1001,19,64,'2025-08-11 20:18:00'),(380,'北京','2025-08-30','05:41:00','18:51:00','12:35:00','21:58:00','蛾眉月','801',26,17,'101','多云','153','晴间多云',340,'西北风','1-3',4,276,'西风','1-3',6,'0.0',2,89,1003,18,25,'2025-08-11 20:18:00'),(381,'北京','2025-08-31','05:42:00','18:50:00','13:36:00','22:35:00','上弦月','802',25,16,'100','晴','150','晴',281,'西风','1-3',7,230,'西南风','1-3',7,'0.0',7,89,1003,20,10,'2025-08-11 20:18:00'),(382,'北京','2025-09-01','05:43:00','18:48:00','14:35:00','23:22:00','盈凸月','803',26,16,'100','晴','150','晴',323,'西北风','1-3',4,286,'西北风','1-3',6,'0.0',7,89,1004,21,10,'2025-08-11 20:18:00'),(383,'北京','2025-09-02','05:44:00','18:47:00','15:28:00','00:00:00','盈凸月','803',28,17,'100','晴','150','晴',338,'西北风','1-3',17,292,'西北风','1-3',7,'0.0',7,91,1000,20,20,'2025-08-11 20:18:00'),(384,'北京','2025-09-03','05:45:00','18:45:00','16:14:00','00:17:00','盈凸月','803',27,16,'100','晴','150','晴',27,'东北风','1-3',7,79,'东风','1-3',7,'0.0',7,89,1001,20,5,'2025-08-11 20:18:00'),(385,'北京','2025-09-04','05:46:00','18:43:00','16:53:00','01:20:00','盈凸月','803',26,17,'101','多云','151','多云',35,'东北风','1-3',7,93,'东风','1-3',7,'0.0',7,88,1003,19,25,'2025-08-11 20:18:00'),(386,'北京','2025-09-05','05:47:00','18:42:00','17:26:00','02:28:00','盈凸月','803',26,18,'300','阵雨','151','多云',100,'东风','1-3',15,117,'东南风','1-3',15,'1.1',1,88,1001,21,58,'2025-08-11 20:18:00'),(387,'北京','2025-09-06','05:48:00','18:40:00','17:55:00','03:38:00','盈凸月','803',25,18,'101','多云','350','阵雨',121,'东南风','1-3',15,159,'东南风','1-3',15,'0.0',3,91,1001,21,25,'2025-08-11 20:18:00'),(388,'北京','2025-09-07','05:48:00','18:39:00','18:21:00','04:50:00','盈凸月','803',25,17,'302','雷阵雨','350','阵雨',162,'东南风','1-3',15,95,'东风','1-3',15,'3.0',2,89,1002,19,65,'2025-08-11 20:18:00'),(389,'北京','2025-09-08','05:49:00','18:37:00','18:45:00','06:01:00','满月','804',25,17,'102','少云','150','晴',321,'西北风','1-3',4,127,'东南风','1-3',6,'0.0',6,89,1003,22,20,'2025-08-11 20:18:00'),(390,'北京','2025-09-09','05:50:00','18:35:00','19:09:00','07:12:00','亏凸月','805',25,16,'103','晴间多云','350','阵雨',43,'东北风','1-3',4,42,'东北风','1-3',4,'0.0',3,90,1001,20,25,'2025-08-11 20:18:00'),(467,'上海','2025-08-27','05:28:00','18:26:00','08:59:00','20:29:00','蛾眉月','801',31,25,'103','晴间多云','153','晴间多云',139,'东南风','3-4',26,129,'东南风','3-4',24,'1.9',10,50,1008,25,55,'2025-08-11 20:18:00'),(468,'上海','2025-08-28','05:28:00','18:24:00','09:55:00','20:57:00','蛾眉月','801',31,25,'102','少云','150','晴',136,'东南风','3-4',20,135,'东南风','3-4',20,'0.0',9,79,1009,24,25,'2025-08-11 20:18:00'),(469,'上海','2025-08-29','05:29:00','18:23:00','10:51:00','21:27:00','蛾眉月','801',31,25,'102','少云','151','多云',156,'东南风','1-3',17,153,'东南风','1-3',19,'0.0',9,79,1006,24,20,'2025-08-11 20:18:00'),(470,'上海','2025-08-30','05:30:00','18:22:00','11:48:00','22:03:00','蛾眉月','801',31,25,'302','雷阵雨','302','雷阵雨',160,'东南风','1-3',9,68,'东北风','1-3',7,'5.7',2,81,1009,24,65,'2025-08-11 20:18:00'),(471,'上海','2025-08-31','05:30:00','18:21:00','12:46:00','22:45:00','上弦月','802',30,25,'302','雷阵雨','151','多云',343,'西北风','1-3',6,348,'西北风','1-3',9,'13.4',3,78,1006,25,70,'2025-08-11 20:18:00'),(472,'上海','2025-09-01','05:31:00','18:20:00','13:42:00','23:33:00','盈凸月','803',30,25,'302','雷阵雨','302','雷阵雨',21,'东北风','1-3',13,47,'东北风','1-3',11,'1.2',3,79,1008,24,61,'2025-08-11 20:18:00'),(473,'上海','2025-09-02','05:31:00','18:18:00','14:35:00','00:00:00','盈凸月','803',29,23,'302','雷阵雨','302','雷阵雨',44,'东北风','3-4',26,41,'东北风','3-4',26,'9.0',2,80,1009,24,65,'2025-08-11 20:18:00'),(474,'上海','2025-09-03','05:32:00','18:17:00','15:24:00','00:28:00','盈凸月','803',27,23,'302','雷阵雨','151','多云',50,'东北风','1-3',19,35,'东北风','1-3',17,'13.4',2,81,1008,25,70,'2025-08-11 20:18:00'),(475,'上海','2025-09-04','05:33:00','18:16:00','16:07:00','01:27:00','盈凸月','803',27,22,'300','阵雨','150','晴',20,'东北风','4-5',32,35,'东北风','4-5',30,'1.4',2,80,1006,25,59,'2025-08-11 20:18:00'),(476,'上海','2025-09-05','05:33:00','18:15:00','16:46:00','02:31:00','盈凸月','803',27,21,'101','多云','151','多云',33,'东北风','3-4',28,12,'东北风','3-4',26,'0.0',9,80,1010,25,20,'2025-08-11 20:18:00'),(477,'上海','2025-09-06','05:34:00','18:13:00','17:20:00','03:35:00','盈凸月','803',28,21,'101','多云','153','晴间多云',17,'东北风','1-3',13,62,'东北风','1-3',13,'0.0',2,81,1009,24,25,'2025-08-11 20:18:00'),(478,'上海','2025-09-07','05:34:00','18:12:00','17:52:00','04:40:00','盈凸月','803',28,21,'103','晴间多云','151','多云',170,'南风','1-3',17,148,'东南风','1-3',19,'0.0',5,80,1010,25,25,'2025-08-11 20:18:00'),(479,'上海','2025-09-08','05:35:00','18:11:00','18:23:00','05:44:00','满月','804',29,22,'103','晴间多云','153','晴间多云',262,'西风','4-5',30,330,'西北风','4-5',30,'3.1',3,80,1007,25,56,'2025-08-11 20:18:00'),(480,'上海','2025-09-09','05:35:00','18:10:00','18:54:00','06:49:00','亏凸月','805',28,22,'100','晴','153','晴间多云',316,'西北风','1-3',19,357,'北风','1-3',17,'0.0',8,78,1009,25,20,'2025-08-11 20:18:00'),(497,'广州','2025-08-27','06:08:00','18:51:00','09:27:00','21:11:00','蛾眉月','801',33,25,'302','雷阵雨','302','雷阵雨',49,'东北风','1-3',6,95,'东风','1-3',6,'8.4',2,55,1003,25,60,'2025-08-11 20:18:00'),(498,'广州','2025-08-28','06:09:00','18:50:00','10:18:00','21:43:00','蛾眉月','801',32,25,'103','晴间多云','350','阵雨',42,'东北风','1-3',7,47,'东北风','1-3',7,'0.0',11,77,1003,19,25,'2025-08-11 20:18:00'),(499,'广州','2025-08-29','06:09:00','18:49:00','11:10:00','22:18:00','蛾眉月','801',32,25,'103','晴间多云','350','阵雨',54,'东北风','3-4',20,76,'东北风','1-3',19,'0.0',10,78,1005,22,25,'2025-08-11 20:18:00'),(500,'广州','2025-08-30','06:09:00','18:48:00','12:03:00','22:57:00','蛾眉月','801',32,25,'302','雷阵雨','350','阵雨',67,'东北风','3-4',20,84,'东风','3-4',20,'1.2',7,79,1003,20,61,'2025-08-11 20:18:00'),(501,'广州','2025-08-31','06:10:00','18:47:00','12:57:00','23:41:00','上弦月','802',32,25,'302','雷阵雨','350','阵雨',82,'东风','3-4',20,79,'东风','1-3',19,'2.5',3,79,1005,21,65,'2025-08-11 20:18:00'),(502,'广州','2025-09-01','06:10:00','18:46:00','13:52:00','00:00:00','盈凸月','803',31,26,'101','多云','302','雷阵雨',68,'东北风','1-3',15,84,'东风','1-3',11,'1.3',3,79,1005,19,41,'2025-08-11 20:18:00'),(503,'广州','2025-09-02','06:10:00','18:45:00','14:45:00','00:31:00','盈凸月','803',31,25,'103','晴间多云','151','多云',37,'东北风','1-3',6,104,'东南风','1-3',4,'2.1',11,79,1005,18,55,'2025-08-11 20:18:00'),(504,'广州','2025-09-03','06:11:00','18:44:00','15:36:00','01:25:00','盈凸月','803',32,25,'103','晴间多云','350','阵雨',30,'东北风','1-3',4,88,'东风','1-3',7,'0.6',7,78,1004,19,40,'2025-08-11 20:18:00'),(505,'广州','2025-09-04','06:11:00','18:43:00','16:22:00','02:23:00','盈凸月','803',32,24,'302','雷阵雨','302','雷阵雨',40,'东北风','1-3',7,55,'东北风','1-3',7,'1.7',4,77,1002,21,64,'2025-08-11 20:18:00'),(506,'广州','2025-09-05','06:11:00','18:42:00','17:03:00','03:22:00','盈凸月','803',32,25,'302','雷阵雨','151','多云',41,'东北风','1-3',7,90,'东风','1-3',11,'1.5',5,77,1003,20,62,'2025-08-11 20:18:00'),(507,'广州','2025-09-06','06:12:00','18:41:00','17:43:00','04:23:00','盈凸月','803',31,25,'300','阵雨','302','雷阵雨',75,'东北风','1-3',17,101,'东风','1-3',15,'0.7',7,77,1002,22,56,'2025-08-11 20:18:00'),(508,'广州','2025-09-07','06:12:00','18:40:00','18:20:00','05:22:00','盈凸月','803',31,24,'103','晴间多云','153','晴间多云',72,'东北风','1-3',7,92,'东风','1-3',7,'0.9',5,76,1005,19,58,'2025-08-11 20:18:00'),(509,'广州','2025-09-08','06:12:00','18:39:00','18:55:00','06:22:00','满月','804',32,25,'100','晴','153','晴间多云',14,'东北风','1-3',6,36,'东北风','1-3',11,'0.9',10,76,1004,19,40,'2025-08-11 20:18:00'),(510,'广州','2025-09-09','06:12:00','18:38:00','19:31:00','07:21:00','亏凸月','805',32,25,'102','少云','350','阵雨',29,'东北风','3-4',20,66,'东北风','1-3',19,'0.6',10,80,1004,22,39,'2025-08-11 20:18:00'),(527,'深圳','2025-08-27','06:06:00','18:47:00','09:23:00','21:08:00','蛾眉月','801',33,27,'302','雷阵雨','151','多云',60,'东北风','3-4',20,94,'东风','3-4',20,'2.1',4,76,996,23,64,'2025-08-11 20:18:00'),(528,'深圳','2025-08-28','06:06:00','18:46:00','10:14:00','21:40:00','蛾眉月','801',32,27,'103','晴间多云','302','雷阵雨',82,'东风','3-4',24,80,'东风','3-4',20,'2.6',11,84,997,19,58,'2025-08-11 20:18:00'),(529,'深圳','2025-08-29','06:06:00','18:45:00','11:05:00','22:15:00','蛾眉月','801',32,27,'302','雷阵雨','151','多云',79,'东风','4-5',32,86,'东风','4-5',30,'5.5',4,84,995,18,65,'2025-08-11 20:18:00'),(530,'深圳','2025-08-30','06:07:00','18:44:00','11:58:00','22:55:00','蛾眉月','801',31,26,'302','雷阵雨','302','雷阵雨',84,'东风','4-5',32,93,'东风','4-5',30,'8.2',3,86,997,18,62,'2025-08-11 20:18:00'),(531,'深圳','2025-08-31','06:07:00','18:43:00','12:53:00','23:39:00','上弦月','802',31,27,'302','雷阵雨','302','雷阵雨',102,'东南风','3-4',28,98,'东风','3-4',28,'8.2',2,85,995,21,60,'2025-08-11 20:18:00'),(532,'深圳','2025-09-01','06:07:00','18:42:00','13:47:00','00:00:00','盈凸月','803',31,27,'302','雷阵雨','302','雷阵雨',94,'东风','3-4',20,89,'东风','1-3',19,'4.9',4,86,998,21,65,'2025-08-11 20:18:00'),(533,'深圳','2025-09-02','06:07:00','18:41:00','14:41:00','00:29:00','盈凸月','803',32,27,'300','阵雨','151','多云',84,'东风','3-4',20,99,'东风','1-3',13,'7.5',11,85,997,22,58,'2025-08-11 20:18:00'),(534,'深圳','2025-09-03','06:08:00','18:41:00','15:31:00','01:23:00','盈凸月','803',32,27,'302','雷阵雨','350','阵雨',54,'东北风','1-3',7,44,'东北风','1-3',4,'1.5',4,85,995,19,63,'2025-08-11 20:18:00'),(535,'深圳','2025-09-04','06:08:00','18:40:00','16:17:00','02:21:00','盈凸月','803',32,26,'302','雷阵雨','302','雷阵雨',63,'东北风','1-3',15,70,'东北风','1-3',11,'3.1',3,86,995,19,65,'2025-08-11 20:18:00'),(536,'深圳','2025-09-05','06:08:00','18:39:00','16:59:00','03:20:00','盈凸月','803',32,26,'302','雷阵雨','302','雷阵雨',61,'东北风','3-4',20,77,'东北风','3-4',20,'2.9',4,85,997,18,65,'2025-08-11 20:18:00'),(537,'深圳','2025-09-06','06:09:00','18:38:00','17:39:00','04:20:00','盈凸月','803',31,26,'101','多云','302','雷阵雨',82,'东风','3-4',28,98,'东风','3-4',26,'1.9',3,85,994,20,41,'2025-08-11 20:18:00'),(538,'深圳','2025-09-07','06:09:00','18:37:00','18:16:00','05:19:00','盈凸月','803',31,26,'302','雷阵雨','153','晴间多云',90,'东风','3-4',22,99,'东风','3-4',20,'2.3',3,83,998,21,65,'2025-08-11 20:18:00'),(539,'深圳','2025-09-08','06:09:00','18:36:00','18:52:00','06:18:00','满月','804',32,26,'102','少云','302','雷阵雨',77,'东北风','1-3',17,72,'东北风','1-3',13,'1.4',11,86,996,21,55,'2025-08-11 20:18:00'),(540,'深圳','2025-09-09','06:09:00','18:35:00','19:28:00','07:18:00','亏凸月','805',32,27,'302','雷阵雨','302','雷阵雨',68,'东北风','3-4',24,81,'东风','3-4',22,'2.0',3,85,998,21,64,'2025-08-11 20:18:00');

insert  into travel_rag.train_tickets(`id`,`departure_city`,`arrival_city`,`departure_time`,`arrival_time`,`train_number`,`seat_type`,`total_seats`,`remaining_seats`,`price`,`created_at`) values (1,'北京','上海','2025-08-02 20:36:00','2025-08-02 22:36:00','G703','二等座',183,183,'167.85','2025-07-27 16:04:25'),(2,'深圳','上海','2025-08-08 17:00:00','2025-08-08 23:00:00','G195','商务座',286,286,'1032.21','2025-07-27 16:04:25'),(3,'广州','上海','2025-07-28 15:45:00','2025-07-28 18:45:00','G567','一等座',106,106,'651.42','2025-07-27 16:04:25'),(4,'广州','北京','2025-08-18 23:30:00','2025-08-19 05:30:00','G854','一等座',207,207,'721.96','2025-07-27 16:04:25'),(5,'广州','深圳','2025-08-13 16:50:00','2025-08-13 22:50:00','G280','二等座',283,283,'160.49','2025-07-27 16:04:25'),(6,'北京','广州','2025-08-16 22:08:00','2025-08-17 03:08:00','G751','二等座',280,280,'217.92','2025-07-27 16:04:25'),(7,'深圳','上海','2025-08-17 13:28:00','2025-08-17 18:28:00','G400','商务座',248,248,'1060.86','2025-07-27 16:04:25'),(8,'广州','深圳','2025-08-21 21:24:00','2025-08-21 23:24:00','G561','商务座',265,265,'812.59','2025-07-27 16:04:25'),(9,'上海','广州','2025-08-04 18:22:00','2025-08-05 00:22:00','G926','二等座',242,242,'318.26','2025-07-27 16:04:25'),(10,'北京','深圳','2025-08-11 13:23:00','2025-08-11 18:23:00','G556','二等座',100,100,'331.84','2025-07-27 16:04:25'),(11,'上海','广州','2025-08-21 20:20:00','2025-08-21 22:20:00','G305','商务座',154,154,'956.04','2025-07-27 16:04:25'),(12,'广州','深圳','2025-07-27 10:06:00','2025-07-27 14:06:00','G674','商务座',165,165,'1013.28','2025-07-27 16:04:25'),(13,'广州','上海','2025-08-20 18:58:00','2025-08-20 20:58:00','G778','商务座',210,210,'952.15','2025-07-27 16:04:25'),(14,'北京','上海','2025-08-26 19:58:00','2025-08-27 00:00:00','G346','二等座',284,284,'397.55','2025-07-27 16:04:25'),(15,'上海','深圳','2025-08-15 14:25:00','2025-08-15 17:25:00','G854','二等座',115,115,'143.30','2025-07-27 16:04:25'),(16,'深圳','上海','2025-08-17 16:45:00','2025-08-17 21:45:00','G466','二等座',147,147,'314.59','2025-07-27 16:04:25'),(17,'北京','上海','2025-07-28 14:25:00','2025-07-28 19:25:00','G715','一等座',282,282,'539.17','2025-07-27 16:04:25'),(18,'北京','广州','2025-08-13 11:35:00','2025-08-13 16:35:00','G188','商务座',263,263,'1157.71','2025-07-27 16:04:25'),(19,'深圳','上海','2025-08-18 23:07:00','2025-08-19 03:07:00','G472','商务座',259,259,'815.69','2025-07-27 16:04:25'),(20,'广州','北京','2025-08-08 12:31:00','2025-08-08 14:31:00','G880','一等座',104,104,'500.71','2025-07-27 16:04:25'),(21,'北京','广州','2025-08-15 10:04:00','2025-08-15 13:04:00','G361','一等座',164,164,'646.70','2025-07-27 16:04:25'),(22,'北京','广州','2025-08-23 22:33:00','2025-08-24 01:33:00','G499','商务座',228,228,'816.56','2025-07-27 16:04:25'),(23,'广州','上海','2025-07-30 06:58:00','2025-07-30 08:58:00','G229','商务座',158,158,'984.22','2025-07-27 16:04:25'),(24,'北京','广州','2025-08-18 18:17:00','2025-08-19 00:17:00','G407','商务座',229,229,'1117.76','2025-07-27 16:04:25'),(25,'深圳','上海','2025-08-07 07:20:00','2025-08-07 11:20:00','G359','商务座',183,183,'985.25','2025-07-27 16:04:25'),(26,'广州','上海','2025-08-26 22:42:00','2025-08-27 00:00:00','G135','二等座',162,162,'435.84','2025-07-27 16:04:25'),(27,'北京','上海','2025-08-02 21:15:00','2025-08-02 23:15:00','G499','商务座',254,254,'964.94','2025-07-27 16:04:25'),(28,'上海','北京','2025-08-21 07:42:00','2025-08-21 10:42:00','G264','二等座',254,254,'409.88','2025-07-27 16:04:25'),(29,'上海','广州','2025-08-05 23:49:00','2025-08-06 02:49:00','G175','商务座',279,279,'881.48','2025-07-27 16:04:25'),(30,'北京','深圳','2025-08-10 11:49:00','2025-08-10 16:49:00','G985','商务座',107,107,'1108.01','2025-07-27 16:04:25'),(31,'上海','广州','2025-08-09 21:21:00','2025-08-10 03:21:00','G373','一等座',256,256,'532.61','2025-07-27 16:04:25'),(32,'广州','深圳','2025-07-30 13:42:00','2025-07-30 18:42:00','G536','一等座',241,241,'647.11','2025-07-27 16:04:25'),(33,'深圳','广州','2025-08-27 11:39:00','2025-08-27 00:00:00','G303','一等座',214,214,'661.10','2025-07-27 16:04:25'),(34,'北京','深圳','2025-08-27 21:46:00','2025-08-27 00:00:00','G416','商务座',181,181,'973.53','2025-07-27 16:04:25'),(35,'北京','广州','2025-08-11 18:08:00','2025-08-11 20:08:00','G529','商务座',164,164,'860.61','2025-07-27 16:04:25'),(36,'北京','深圳','2025-08-27 14:30:00','2025-08-27 00:00:00','G767','二等座',100,100,'377.62','2025-07-27 16:04:25'),(37,'上海','深圳','2025-08-16 10:18:00','2025-08-16 13:18:00','G717','二等座',300,300,'348.43','2025-07-27 16:04:25'),(38,'北京','广州','2025-08-05 08:51:00','2025-08-05 14:51:00','G295','商务座',202,202,'833.75','2025-07-27 16:04:25'),(39,'深圳','广州','2025-08-27 23:45:00','2025-08-27 00:00:00','G444','商务座',136,136,'1096.68','2025-07-27 16:04:25'),(40,'北京','深圳','2025-08-04 15:28:00','2025-08-04 21:28:00','G591','商务座',110,110,'850.18','2025-07-27 16:04:25'),(41,'上海','深圳','2025-08-11 17:24:00','2025-08-11 20:24:00','G997','一等座',199,199,'507.04','2025-07-27 16:04:25'),(42,'深圳','北京','2025-07-31 21:52:00','2025-07-31 23:52:00','G129','二等座',264,264,'334.37','2025-07-27 16:04:25'),(43,'上海','广州','2025-08-05 08:46:00','2025-08-05 14:46:00','G546','一等座',152,152,'576.66','2025-07-27 16:04:25'),(44,'上海','深圳','2025-08-03 23:12:00','2025-08-04 03:12:00','G929','一等座',213,213,'570.96','2025-07-27 16:04:25'),(45,'上海','北京','2025-08-19 13:11:00','2025-08-19 16:11:00','G942','商务座',197,197,'808.51','2025-07-27 16:04:25'),(46,'广州','北京','2025-08-06 15:32:00','2025-08-06 20:32:00','G118','商务座',288,288,'851.79','2025-07-27 16:04:25'),(47,'广州','北京','2025-08-06 18:31:00','2025-08-06 23:31:00','G423','一等座',123,123,'613.49','2025-07-27 16:04:25'),(48,'深圳','北京','2025-08-08 11:52:00','2025-08-08 13:52:00','G565','二等座',223,223,'330.15','2025-07-27 16:04:25'),(49,'上海','广州','2025-07-29 16:57:00','2025-07-29 21:57:00','G999','商务座',261,261,'976.29','2025-07-27 16:04:25'),(50,'上海','广州','2025-08-03 10:08:00','2025-08-03 12:08:00','G874','商务座',201,201,'810.12','2025-07-27 16:04:25'),(51,'上海','广州','2025-08-11 21:00:00','2025-08-12 00:00:00','G646','二等座',289,289,'353.64','2025-07-27 16:04:25'),(52,'北京','上海','2025-08-20 10:24:00','2025-08-20 16:24:00','G273','商务座',245,245,'949.04','2025-07-27 16:04:25'),(53,'深圳','广州','2025-07-31 12:07:00','2025-07-31 18:07:00','G415','一等座',140,140,'660.54','2025-07-27 16:04:25'),(54,'北京','广州','2025-08-13 19:00:00','2025-08-13 23:00:00','G684','商务座',278,278,'1010.40','2025-07-27 16:04:25'),(55,'北京','上海','2025-08-01 10:31:00','2025-08-01 13:31:00','G283','一等座',201,201,'799.32','2025-07-27 16:04:25'),(56,'北京','上海','2025-08-12 13:04:00','2025-08-12 19:04:00','G135','商务座',103,103,'986.00','2025-07-27 16:04:25'),(57,'深圳','北京','2025-08-13 08:28:00','2025-08-13 11:28:00','G111','二等座',124,124,'392.69','2025-07-27 16:04:25'),(58,'广州','深圳','2025-08-15 08:46:00','2025-08-15 10:46:00','G502','二等座',178,178,'110.15','2025-07-27 16:04:25'),(59,'广州','北京','2025-08-23 08:44:00','2025-08-23 10:44:00','G948','商务座',195,195,'1021.77','2025-07-27 16:04:25'),(60,'深圳','上海','2025-08-23 12:18:00','2025-08-23 17:18:00','G447','二等座',219,219,'331.16','2025-07-27 16:04:25'),(61,'深圳','广州','2025-07-31 17:27:00','2025-07-31 21:27:00','G303','一等座',212,212,'703.15','2025-07-27 16:04:25'),(62,'上海','广州','2025-08-15 19:57:00','2025-08-16 01:57:00','G185','二等座',237,237,'295.43','2025-07-27 16:04:25'),(63,'北京','上海','2025-08-06 13:06:00','2025-08-06 17:06:00','G795','一等座',290,290,'564.04','2025-07-27 16:04:25'),(64,'广州','上海','2025-08-14 09:49:00','2025-08-14 14:49:00','G400','商务座',267,267,'1045.80','2025-07-27 16:04:25'),(65,'北京','广州','2025-08-27 20:47:00','2025-08-27 00:00:00','G242','二等座',262,262,'209.73','2025-07-27 16:04:25'),(66,'广州','深圳','2025-08-05 15:33:00','2025-08-05 18:33:00','G804','一等座',155,155,'676.63','2025-07-27 16:04:25'),(67,'上海','广州','2025-08-27 11:10:00','2025-08-27 00:00:00','G311','一等座',248,248,'703.68','2025-07-27 16:04:25'),(68,'北京','广州','2025-08-14 18:59:00','2025-08-14 23:59:00','G389','商务座',247,247,'1164.69','2025-07-27 16:04:25'),(69,'上海','北京','2025-08-24 21:01:00','2025-08-25 00:01:00','G365','商务座',234,234,'893.20','2025-07-27 16:04:25'),(70,'北京','广州','2025-07-29 12:02:00','2025-07-29 18:02:00','G716','一等座',228,228,'791.22','2025-07-27 16:04:25'),(71,'上海','广州','2025-08-07 21:58:00','2025-08-08 00:58:00','G326','二等座',233,233,'109.16','2025-07-27 16:04:25'),(72,'深圳','广州','2025-08-19 23:28:00','2025-08-20 03:28:00','G954','商务座',175,175,'1033.73','2025-07-27 16:04:25'),(73,'广州','北京','2025-08-21 19:29:00','2025-08-22 00:29:00','G658','一等座',128,128,'686.68','2025-07-27 16:04:25'),(74,'广州','北京','2025-08-09 16:26:00','2025-08-09 22:26:00','G268','商务座',214,214,'850.37','2025-07-27 16:04:25'),(75,'广州','深圳','2025-08-25 16:28:00','2025-08-25 19:28:00','G983','二等座',163,163,'389.07','2025-07-27 16:04:25'),(76,'广州','北京','2025-07-31 17:37:00','2025-07-31 21:37:00','G798','一等座',288,288,'552.14','2025-07-27 16:04:25'),(77,'深圳','上海','2025-07-30 12:55:00','2025-07-30 18:55:00','G806','一等座',300,300,'531.94','2025-07-27 16:04:25'),(78,'深圳','广州','2025-08-05 10:25:00','2025-08-05 16:25:00','G287','商务座',107,107,'1002.25','2025-07-27 16:04:25'),(79,'北京','深圳','2025-08-20 21:55:00','2025-08-21 02:55:00','G196','商务座',242,242,'1111.37','2025-07-27 16:04:25'),(80,'深圳','广州','2025-08-04 19:04:00','2025-08-05 01:04:00','G384','商务座',177,177,'1045.08','2025-07-27 16:04:25'),(81,'上海','深圳','2025-08-14 18:57:00','2025-08-14 22:57:00','G680','二等座',240,240,'358.23','2025-07-27 16:04:25'),(82,'上海','广州','2025-07-28 20:11:00','2025-07-28 23:11:00','G813','二等座',140,140,'182.71','2025-07-27 16:04:25'),(83,'上海','广州','2025-08-23 11:37:00','2025-08-23 16:37:00','G446','商务座',152,152,'992.52','2025-07-27 16:04:25'),(84,'上海','广州','2025-07-30 21:30:00','2025-07-30 23:30:00','G251','一等座',253,253,'570.24','2025-07-27 16:04:25'),(85,'广州','深圳','2025-08-26 21:53:00','2025-08-27 00:00:00','G113','商务座',275,275,'1143.96','2025-07-27 16:04:25'),(86,'上海','广州','2025-07-27 12:12:00','2025-07-27 18:12:00','G841','一等座',284,284,'768.87','2025-07-27 16:04:25'),(87,'广州','上海','2025-08-06 08:19:00','2025-08-06 13:19:00','G970','商务座',276,276,'1055.65','2025-07-27 16:04:25'),(88,'深圳','北京','2025-08-25 10:02:00','2025-08-25 16:02:00','G611','一等座',194,194,'551.83','2025-07-27 16:04:25'),(89,'深圳','北京','2025-08-13 09:39:00','2025-08-13 13:39:00','G588','商务座',258,258,'817.85','2025-07-27 16:04:25'),(90,'上海','北京','2025-07-27 22:12:00','2025-07-28 01:12:00','G434','一等座',147,147,'741.97','2025-07-27 16:04:25'),(91,'广州','上海','2025-08-24 23:13:00','2025-08-25 04:13:00','G764','商务座',280,280,'890.17','2025-07-27 16:04:25'),(92,'上海','北京','2025-08-18 20:31:00','2025-08-18 23:31:00','G355','商务座',232,232,'960.37','2025-07-27 16:04:25'),(93,'深圳','上海','2025-08-13 17:12:00','2025-08-13 22:12:00','G104','一等座',219,219,'513.02','2025-07-27 16:04:25'),(94,'深圳','北京','2025-07-27 14:59:00','2025-07-27 16:59:00','G656','二等座',144,144,'403.38','2025-07-27 16:04:25'),(95,'上海','北京','2025-08-21 10:36:00','2025-08-21 14:36:00','G188','二等座',296,296,'187.76','2025-07-27 16:04:25'),(96,'上海','北京','2025-08-02 20:09:00','2025-08-03 01:09:00','G276','一等座',252,252,'628.64','2025-07-27 16:04:25'),(97,'北京','深圳','2025-08-16 11:04:00','2025-08-16 17:04:00','G670','一等座',182,182,'606.45','2025-07-27 16:04:25'),(98,'深圳','北京','2025-07-30 08:13:00','2025-07-30 10:13:00','G327','商务座',107,107,'1004.35','2025-07-27 16:04:25'),(99,'深圳','广州','2025-08-14 15:50:00','2025-08-14 20:50:00','G348','一等座',237,237,'611.31','2025-07-27 16:04:25'),(100,'广州','北京','2025-08-12 09:51:00','2025-08-12 13:51:00','G273','商务座',108,108,'816.47','2025-07-27 16:04:25'),(101,'广州','上海','2025-08-14 11:35:00','2025-08-14 14:35:00','G294','商务座',154,154,'1058.42','2025-07-27 16:04:25'),(102,'上海','北京','2025-08-19 16:52:00','2025-08-19 18:52:00','G604','二等座',140,140,'250.95','2025-07-27 16:04:25'),(103,'广州','北京','2025-07-30 09:44:00','2025-07-30 14:44:00','G950','商务座',162,162,'1019.56','2025-07-27 16:04:25'),(104,'北京','深圳','2025-08-15 11:42:00','2025-08-15 15:42:00','G681','一等座',123,123,'651.70','2025-07-27 16:04:25'),(105,'广州','北京','2025-08-21 19:30:00','2025-08-21 22:30:00','G487','一等座',294,294,'730.46','2025-07-27 16:04:25'),(106,'深圳','北京','2025-08-19 15:04:00','2025-08-19 20:04:00','G583','二等座',140,140,'205.26','2025-07-27 16:04:25'),(107,'上海','广州','2025-08-11 14:03:00','2025-08-11 18:03:00','G995','商务座',204,204,'964.67','2025-07-27 16:04:25'),(108,'上海','深圳','2025-08-26 22:16:00','2025-08-27 00:00:00','G725','一等座',103,103,'585.21','2025-07-27 16:04:25'),(109,'上海','北京','2025-08-08 09:57:00','2025-08-08 13:57:00','G660','商务座',149,149,'812.18','2025-07-27 16:04:25'),(110,'深圳','广州','2025-08-12 12:24:00','2025-08-12 17:24:00','G708','商务座',277,277,'1115.17','2025-07-27 16:04:25'),(111,'上海','深圳','2025-08-03 13:15:00','2025-08-03 16:15:00','G136','二等座',241,241,'196.91','2025-07-27 16:04:25'),(112,'广州','深圳','2025-08-21 07:46:00','2025-08-21 12:46:00','G482','一等座',210,210,'541.67','2025-07-27 16:04:25'),(113,'北京','深圳','2025-08-20 19:53:00','2025-08-20 21:53:00','G374','二等座',147,147,'239.14','2025-07-27 16:04:25'),(114,'上海','广州','2025-08-24 13:04:00','2025-08-24 15:04:00','G516','二等座',127,127,'404.41','2025-07-27 16:04:25'),(115,'广州','深圳','2025-08-14 20:00:00','2025-08-15 01:00:00','G509','二等座',134,134,'269.29','2025-07-27 16:04:25'),(116,'北京','深圳','2025-08-23 08:24:00','2025-08-23 13:24:00','G944','二等座',179,179,'449.69','2025-07-27 16:04:25'),(117,'广州','上海','2025-08-26 16:34:00','2025-08-26 19:34:00','G292','商务座',246,246,'943.47','2025-07-27 16:04:25'),(118,'广州','深圳','2025-08-03 10:33:00','2025-08-03 14:33:00','G244','商务座',156,156,'1042.67','2025-07-27 16:04:25'),(119,'上海','北京','2025-08-05 18:54:00','2025-08-05 23:54:00','G132','商务座',220,220,'1086.29','2025-07-27 16:04:25'),(120,'上海','广州','2025-08-03 10:25:00','2025-08-03 13:25:00','G758','一等座',191,191,'517.92','2025-07-27 16:04:25');

insert  into travel_rag.flight_tickets(`id`,`departure_city`,`arrival_city`,`departure_time`,`arrival_time`,`flight_number`,`cabin_type`,`total_seats`,`remaining_seats`,`price`,`created_at`) values (1,'上海','北京','2025-09-21 22:00:00','2025-08-27 00:00:00','CA7151','公务舱',148,148,'1311.36','2025-07-27 16:04:21'),(2,'北京','深圳','2025-08-13 09:36:00','2025-08-13 11:36:00','CA1270','头等舱',119,119,'2290.31','2025-07-27 16:04:21'),(3,'上海','北京','2025-08-01 00:27:00','2025-08-01 05:27:00','CA6557','经济舱',134,134,'885.65','2025-07-27 16:04:21'),(4,'广州','深圳','2025-08-09 22:23:00','2025-08-10 02:23:00','CA3321','头等舱',87,87,'2736.43','2025-07-27 16:04:21'),(5,'上海','深圳','2025-08-15 09:32:00','2025-08-15 14:32:00','CA5040','头等舱',146,146,'2455.01','2025-07-27 16:04:21'),(6,'北京','上海','2025-08-22 21:20:00','2025-08-22 23:20:00','CA3624','公务舱',57,57,'1601.75','2025-07-27 16:04:21'),(7,'北京','广州','2025-08-03 17:20:00','2025-08-03 21:20:00','CA1906','公务舱',81,81,'1731.53','2025-07-27 16:04:21'),(8,'上海','北京','2025-09-10 21:46:00','2025-08-27 00:00:00','CA8096','经济舱',93,93,'680.94','2025-07-27 16:04:21'),(9,'上海','广州','2025-09-11 11:57:00','2025-08-27 00:00:00','CA6284','头等舱',149,149,'2851.80','2025-07-27 16:04:21'),(10,'上海','北京','2025-09-02 11:26:00','2025-08-27 00:00:00','CA6382','头等舱',96,96,'2835.52','2025-07-27 16:04:21'),(11,'广州','上海','2025-09-24 16:30:00','2025-08-27 00:00:00','CA6744','经济舱',105,105,'958.30','2025-07-27 16:04:21'),(12,'上海','广州','2025-08-24 22:39:00','2025-08-25 02:39:00','CA1212','公务舱',52,52,'1337.76','2025-07-27 16:04:21'),(13,'深圳','广州','2025-09-09 20:06:00','2025-08-27 00:00:00','CA5548','经济舱',125,125,'990.82','2025-07-27 16:04:21'),(14,'北京','深圳','2025-09-12 18:40:00','2025-08-27 00:00:00','CA1459','头等舱',130,130,'2410.36','2025-07-27 16:04:21'),(15,'深圳','上海','2025-09-23 18:50:00','2025-08-27 00:00:00','CA5385','经济舱',75,75,'665.93','2025-07-27 16:04:21'),(16,'深圳','广州','2025-09-16 22:14:00','2025-08-27 00:00:00','CA5159','头等舱',89,89,'2301.25','2025-07-27 16:04:21'),(17,'上海','北京','2025-08-10 13:15:00','2025-08-10 14:15:00','CA5696','经济舱',129,129,'604.37','2025-07-27 16:04:21'),(18,'上海','北京','2025-08-11 22:52:00','2025-08-12 02:52:00','CA8751','经济舱',96,96,'678.59','2025-07-27 16:04:21'),(19,'广州','上海','2025-08-02 00:11:00','2025-08-02 05:11:00','CA4339','经济舱',101,101,'631.34','2025-07-27 16:04:21'),(20,'广州','上海','2025-08-18 15:42:00','2025-08-18 16:42:00','CA3244','经济舱',114,114,'806.98','2025-07-27 16:04:21'),(21,'深圳','广州','2025-07-30 22:33:00','2025-07-30 23:33:00','CA4724','头等舱',87,87,'2996.21','2025-07-27 16:04:21'),(22,'广州','北京','2025-08-01 15:06:00','2025-08-01 16:06:00','CA4167','经济舱',51,51,'749.33','2025-07-27 16:04:21'),(23,'广州','北京','2025-09-08 14:05:00','2025-08-27 00:00:00','CA3184','头等舱',59,59,'2386.98','2025-07-27 16:04:21'),(24,'深圳','广州','2025-09-16 13:30:00','2025-08-27 00:00:00','CA2898','公务舱',69,69,'1581.42','2025-07-27 16:04:21'),(25,'上海','深圳','2025-09-24 00:38:00','2025-08-27 00:00:00','CA4504','公务舱',79,79,'1724.66','2025-07-27 16:04:21'),(26,'上海','深圳','2025-08-20 13:54:00','2025-08-20 18:54:00','CA8638','头等舱',94,94,'2472.95','2025-07-27 16:04:21'),(27,'深圳','上海','2025-08-03 19:03:00','2025-08-03 23:03:00','CA1764','头等舱',123,123,'2560.29','2025-07-27 16:04:21'),(28,'上海','深圳','2025-08-27 16:32:00','2025-08-27 00:00:00','CA7695','头等舱',135,135,'2593.06','2025-07-27 16:04:21'),(29,'上海','深圳','2025-09-11 15:54:00','2025-08-27 00:00:00','CA2637','公务舱',66,66,'1856.64','2025-07-27 16:04:21'),(30,'上海','广州','2025-09-24 08:48:00','2025-08-27 00:00:00','CA3274','经济舱',76,76,'926.89','2025-07-27 16:04:21'),(31,'广州','北京','2025-08-16 16:14:00','2025-08-16 18:14:00','CA3246','公务舱',62,62,'1438.12','2025-07-27 16:04:21'),(32,'深圳','北京','2025-08-28 12:14:00','2025-08-27 00:00:00','CA2174','经济舱',131,131,'1121.44','2025-07-27 16:04:21'),(33,'北京','上海','2025-09-01 15:32:00','2025-08-27 00:00:00','CA2714','经济舱',133,133,'629.95','2025-07-27 16:04:21'),(34,'上海','北京','2025-08-08 09:04:00','2025-08-08 12:04:00','CA1284','公务舱',82,82,'1638.03','2025-07-27 16:04:21'),(35,'北京','广州','2025-09-03 22:08:00','2025-08-27 00:00:00','CA6851','经济舱',56,56,'503.59','2025-07-27 16:04:21'),(36,'广州','北京','2025-08-03 22:30:00','2025-08-04 03:30:00','CA7417','头等舱',72,72,'2014.35','2025-07-27 16:04:21'),(37,'深圳','上海','2025-07-31 07:45:00','2025-07-31 10:45:00','CA8102','经济舱',70,70,'853.45','2025-07-27 16:04:21'),(38,'北京','上海','2025-07-30 12:46:00','2025-07-30 17:46:00','CA2104','头等舱',58,58,'2938.34','2025-07-27 16:04:21'),(39,'北京','上海','2025-08-11 09:03:00','2025-08-11 12:03:00','CA1085','经济舱',80,80,'923.65','2025-07-27 16:04:21'),(40,'深圳','北京','2025-08-28 12:31:00','2025-08-27 00:00:00','CA5786','经济舱',98,98,'1096.58','2025-07-27 16:04:21'),(41,'深圳','北京','2025-09-17 14:03:00','2025-08-27 00:00:00','CA7813','经济舱',119,119,'1146.29','2025-07-27 16:04:21'),(42,'北京','广州','2025-08-28 08:15:00','2025-08-27 00:00:00','CA3636','公务舱',58,58,'1560.16','2025-07-27 16:04:21'),(43,'广州','北京','2025-09-02 13:23:00','2025-08-27 00:00:00','CA8286','公务舱',136,136,'1599.04','2025-07-27 16:04:21'),(44,'广州','深圳','2025-09-19 07:13:00','2025-08-27 00:00:00','CA4803','头等舱',88,88,'2556.78','2025-07-27 16:04:21'),(45,'广州','上海','2025-09-06 19:26:00','2025-08-27 00:00:00','CA9428','头等舱',56,56,'2478.31','2025-07-27 16:04:21'),(46,'广州','北京','2025-09-08 15:44:00','2025-08-27 00:00:00','CA3851','公务舱',81,81,'1774.53','2025-07-27 16:04:21'),(47,'上海','广州','2025-08-12 14:02:00','2025-08-12 16:02:00','CA2493','头等舱',150,150,'2898.23','2025-07-27 16:04:21'),(48,'深圳','上海','2025-09-07 00:34:00','2025-08-27 00:00:00','CA6405','经济舱',95,95,'555.32','2025-07-27 16:04:21'),(49,'广州','北京','2025-09-12 20:15:00','2025-08-27 00:00:00','CA5318','公务舱',62,62,'1991.59','2025-07-27 16:04:21'),(50,'北京','深圳','2025-09-01 21:13:00','2025-08-27 00:00:00','CA8925','公务舱',110,110,'1633.21','2025-07-27 16:04:21'),(51,'上海','广州','2025-09-18 18:35:00','2025-08-27 00:00:00','CA7931','公务舱',123,123,'1304.42','2025-07-27 16:04:21'),(52,'广州','深圳','2025-09-07 07:02:00','2025-08-27 00:00:00','CA8830','经济舱',71,71,'695.24','2025-07-27 16:04:21'),(53,'深圳','北京','2025-09-14 00:28:00','2025-08-27 00:00:00','CA3742','经济舱',57,57,'532.13','2025-07-27 16:04:21'),(54,'广州','上海','2025-09-04 08:51:00','2025-08-27 00:00:00','CA3248','经济舱',85,85,'885.20','2025-07-27 16:04:21'),(55,'北京','深圳','2025-08-13 16:39:00','2025-08-13 17:39:00','CA4473','经济舱',91,91,'506.43','2025-07-27 16:04:21'),(56,'北京','广州','2025-09-16 13:44:00','2025-08-27 00:00:00','CA1201','头等舱',100,100,'2139.98','2025-07-27 16:04:21'),(57,'广州','上海','2025-09-08 16:57:00','2025-08-27 00:00:00','CA7206','经济舱',95,95,'784.11','2025-07-27 16:04:21'),(58,'广州','深圳','2025-08-31 13:14:00','2025-08-27 00:00:00','CA7429','经济舱',54,54,'954.49','2025-07-27 16:04:21'),(59,'上海','深圳','2025-08-10 13:44:00','2025-08-10 14:44:00','CA4709','经济舱',125,125,'594.29','2025-07-27 16:04:21'),(60,'深圳','上海','2025-08-03 08:05:00','2025-08-03 12:05:00','CA4574','头等舱',117,117,'2614.51','2025-07-27 16:04:21'),(61,'深圳','广州','2025-09-14 20:57:00','2025-08-27 00:00:00','CA7019','公务舱',111,111,'1524.63','2025-07-27 16:04:21'),(62,'深圳','广州','2025-09-15 12:41:00','2025-08-27 00:00:00','CA7257','头等舱',101,101,'2210.88','2025-07-27 16:04:21'),(63,'深圳','广州','2025-07-27 16:52:00','2025-07-27 18:52:00','CA8321','公务舱',137,137,'1615.02','2025-07-27 16:04:21'),(64,'北京','上海','2025-08-23 09:59:00','2025-08-23 10:59:00','CA4293','公务舱',98,98,'1878.45','2025-07-27 16:04:21'),(65,'广州','深圳','2025-08-23 10:06:00','2025-08-23 14:06:00','CA8471','头等舱',52,52,'2157.26','2025-07-27 16:04:21'),(66,'广州','北京','2025-08-04 17:13:00','2025-08-04 18:13:00','CA2987','公务舱',75,75,'1770.52','2025-07-27 16:04:21'),(67,'广州','上海','2025-09-24 00:36:00','2025-08-27 00:00:00','CA7851','头等舱',58,58,'2015.88','2025-07-27 16:04:21'),(68,'上海','北京','2025-09-11 19:49:00','2025-08-27 00:00:00','CA7328','头等舱',67,67,'2530.49','2025-07-27 16:04:21'),(69,'北京','广州','2025-08-16 11:41:00','2025-08-16 16:41:00','CA5645','公务舱',108,108,'1840.09','2025-07-27 16:04:21'),(70,'广州','深圳','2025-09-02 19:16:00','2025-08-27 00:00:00','CA4124','头等舱',106,106,'2423.91','2025-07-27 16:04:21'),(71,'广州','深圳','2025-08-26 20:11:00','2025-08-26 22:11:00','CA2124','公务舱',58,58,'1873.24','2025-07-27 16:04:21'),(72,'深圳','北京','2025-08-16 18:06:00','2025-08-16 19:06:00','CA1397','经济舱',109,109,'1058.82','2025-07-27 16:04:21'),(73,'广州','深圳','2025-09-14 23:44:00','2025-08-27 00:00:00','CA8512','头等舱',91,91,'2556.04','2025-07-27 16:04:21'),(74,'深圳','上海','2025-08-27 13:13:00','2025-08-27 00:00:00','CA8073','经济舱',50,50,'612.09','2025-07-27 16:04:21'),(75,'上海','广州','2025-08-29 12:38:00','2025-08-27 00:00:00','CA4782','公务舱',118,118,'1524.59','2025-07-27 16:04:21'),(76,'广州','北京','2025-09-22 12:09:00','2025-08-27 00:00:00','CA7280','经济舱',125,125,'1167.26','2025-07-27 16:04:21'),(77,'深圳','上海','2025-09-22 21:36:00','2025-08-27 00:00:00','CA2829','经济舱',95,95,'518.21','2025-07-27 16:04:21'),(78,'北京','上海','2025-09-05 00:54:00','2025-08-27 00:00:00','CA6247','头等舱',67,67,'2339.68','2025-07-27 16:04:21'),(79,'广州','上海','2025-08-19 15:56:00','2025-08-19 20:56:00','CA4457','头等舱',142,142,'2796.88','2025-07-27 16:04:21'),(80,'北京','上海','2025-08-06 06:57:00','2025-08-06 11:57:00','CA3933','公务舱',104,104,'1499.78','2025-07-27 16:04:21'),(81,'北京','广州','2025-07-31 19:51:00','2025-07-31 20:51:00','CA5990','经济舱',121,121,'711.14','2025-07-27 16:04:21'),(82,'上海','广州','2025-09-01 22:37:00','2025-08-27 00:00:00','CA1435','头等舱',103,103,'2397.56','2025-07-27 16:04:21'),(83,'广州','深圳','2025-08-10 20:34:00','2025-08-10 21:34:00','CA8408','头等舱',104,104,'2512.60','2025-07-27 16:04:21'),(84,'广州','北京','2025-07-30 21:02:00','2025-07-30 22:02:00','CA9211','经济舱',97,97,'1092.13','2025-07-27 16:04:21'),(85,'广州','深圳','2025-09-25 00:52:00','2025-08-27 00:00:00','CA3700','经济舱',102,102,'902.71','2025-07-27 16:04:21'),(86,'广州','上海','2025-07-31 19:46:00','2025-08-01 00:46:00','CA6241','头等舱',109,109,'2894.67','2025-07-27 16:04:21'),(87,'上海','北京','2025-09-14 23:22:00','2025-08-27 00:00:00','CA3245','公务舱',123,123,'1301.33','2025-07-27 16:04:21'),(88,'北京','上海','2025-08-31 21:02:00','2025-08-27 00:00:00','CA9695','头等舱',55,55,'2463.32','2025-07-27 16:04:21'),(89,'广州','深圳','2025-09-25 14:14:00','2025-08-27 00:00:00','CA7785','公务舱',62,62,'1754.83','2025-07-27 16:04:21'),(90,'上海','广州','2025-09-03 19:39:00','2025-08-27 00:00:00','CA6577','头等舱',95,95,'2543.82','2025-07-27 16:04:21'),(91,'北京','广州','2025-08-13 00:04:00','2025-08-13 03:04:00','CA7722','头等舱',137,137,'2344.17','2025-07-27 16:04:21'),(92,'上海','北京','2025-07-28 15:26:00','2025-07-28 18:26:00','CA4722','经济舱',106,106,'878.85','2025-07-27 16:04:21'),(93,'北京','上海','2025-09-17 23:50:00','2025-08-27 00:00:00','CA3197','公务舱',100,100,'1240.91','2025-07-27 16:04:21'),(94,'北京','广州','2025-08-23 18:41:00','2025-08-23 21:41:00','CA4501','经济舱',66,66,'884.40','2025-07-27 16:04:21'),(95,'广州','北京','2025-09-03 12:28:00','2025-08-27 00:00:00','CA5092','头等舱',102,102,'2610.10','2025-07-27 16:04:21'),(96,'深圳','北京','2025-08-19 13:20:00','2025-08-19 16:20:00','CA2989','经济舱',70,70,'829.00','2025-07-27 16:04:21'),(97,'上海','北京','2025-09-18 19:27:00','2025-08-27 00:00:00','CA7162','公务舱',145,145,'1928.03','2025-07-27 16:04:21'),(98,'上海','广州','2025-08-02 23:55:00','2025-08-03 02:55:00','CA2917','经济舱',82,82,'584.62','2025-07-27 16:04:21'),(99,'上海','广州','2025-08-11 15:41:00','2025-08-11 16:41:00','CA7090','经济舱',58,58,'890.63','2025-07-27 16:04:21'),(100,'广州','深圳','2025-08-16 17:37:00','2025-08-16 20:37:00','CA9163','头等舱',50,50,'2405.28','2025-07-27 16:04:21'),(101,'上海','深圳','2025-09-15 14:31:00','2025-08-27 00:00:00','CA7520','经济舱',92,92,'1045.44','2025-07-27 16:04:21'),(102,'上海','北京','2025-09-19 13:51:00','2025-08-27 00:00:00','CA2409','公务舱',88,88,'1442.46','2025-07-27 16:04:21'),(103,'深圳','上海','2025-08-28 11:05:00','2025-08-27 00:00:00','CA5510','头等舱',66,66,'2969.17','2025-07-27 16:04:21'),(104,'深圳','上海','2025-08-02 08:25:00','2025-08-02 11:25:00','CA2274','经济舱',84,84,'546.04','2025-07-27 16:04:21'),(105,'深圳','广州','2025-09-07 19:03:00','2025-08-27 00:00:00','CA5416','经济舱',145,145,'1041.12','2025-07-27 16:04:21'),(106,'广州','上海','2025-08-08 17:17:00','2025-08-08 22:17:00','CA9553','经济舱',108,108,'1172.30','2025-07-27 16:04:21'),(107,'上海','广州','2025-08-07 23:13:00','2025-08-08 00:13:00','CA8253','公务舱',97,97,'1295.42','2025-07-27 16:04:21'),(108,'深圳','上海','2025-09-22 22:33:00','2025-08-27 00:00:00','CA6255','头等舱',94,94,'2729.88','2025-07-27 16:04:21'),(109,'北京','深圳','2025-09-22 00:05:00','2025-08-27 00:00:00','CA7690','头等舱',102,102,'2278.72','2025-07-27 16:04:21'),(110,'北京','广州','2025-08-11 21:01:00','2025-08-12 02:01:00','CA3625','头等舱',61,61,'2150.65','2025-07-27 16:04:21'),(111,'北京','深圳','2025-09-20 10:03:00','2025-08-27 00:00:00','CA5282','经济舱',99,99,'893.35','2025-07-27 16:04:21'),(112,'北京','广州','2025-08-25 10:54:00','2025-08-25 15:54:00','CA5992','公务舱',62,62,'1479.05','2025-07-27 16:04:21'),(113,'广州','北京','2025-08-10 16:02:00','2025-08-10 18:02:00','CA3044','公务舱',73,73,'1573.03','2025-07-27 16:04:21'),(114,'北京','上海','2025-09-09 00:46:00','2025-08-27 00:00:00','CA5397','公务舱',137,137,'1722.66','2025-07-27 16:04:21'),(115,'深圳','广州','2025-09-11 22:03:00','2025-08-27 00:00:00','CA9216','头等舱',91,91,'2712.58','2025-07-27 16:04:21'),(116,'广州','北京','2025-09-04 10:57:00','2025-08-27 00:00:00','CA3316','头等舱',122,122,'2651.39','2025-07-27 16:04:21'),(117,'上海','广州','2025-09-04 15:42:00','2025-08-27 00:00:00','CA1997','公务舱',105,105,'1729.53','2025-07-27 16:04:21'),(118,'广州','北京','2025-08-02 11:53:00','2025-08-02 12:53:00','CA6923','头等舱',127,127,'2537.66','2025-07-27 16:04:21'),(119,'北京','上海','2025-09-19 23:26:00','2025-08-27 00:00:00','CA7566','经济舱',99,99,'1066.76','2025-07-27 16:04:21'),(120,'上海','深圳','2025-08-21 22:29:00','2025-08-22 01:29:00','CA4422','头等舱',118,118,'2441.84','2025-07-27 16:04:21');

insert  into travel_rag.concert_tickets(`id`,`artist`,`city`,`venue`,`start_time`,`end_time`,`ticket_type`,`total_seats`,`remaining_seats`,`price`,`created_at`) values (1,'刀郎','上海','上海体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','内场',403,403,'880.00','2025-07-27 16:05:50'),(2,'张学友','广州','广州体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','看台',431,431,'180.00','2025-07-27 16:05:50'),(3,'周杰伦','上海','上海体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','看台',418,418,'50.00','2025-07-27 16:05:50'),(4,'五月天','上海','上海体育馆','2025-08-03 20:11:00','2025-08-04 00:11:00','VIP',428,428,'1280.00','2025-07-27 16:05:50'),(5,'刀郎','深圳','深圳体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','VIP',282,282,'1080.00','2025-07-27 16:05:50'),(7,'五月天','北京','北京体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','看台',380,380,'480.00','2025-07-27 16:05:50'),(11,'张学友','广州','广州体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','内场',305,305,'680.00','2025-07-27 16:05:50'),(12,'张学友','上海','上海体育馆','2025-08-02 20:55:00','2025-08-02 23:55:00','VIP',454,454,'1080.00','2025-07-27 16:05:50'),(13,'周杰伦','北京','北京体育馆','2025-08-15 20:27:00','2025-08-15 22:27:00','VIP',332,332,'1080.00','2025-07-27 16:05:50'),(16,'五月天','上海','上海体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','内场',365,365,'680.00','2025-07-27 16:05:50'),(17,'张学友','广州','广州体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','VIP',201,201,'1080.00','2025-07-27 16:05:50'),(18,'刀郎','广州','广州体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','看台',388,388,'280.00','2025-07-27 16:05:50'),(22,'周杰伦','广州','广州体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','VIP',257,257,'1280.00','2025-07-27 16:05:50'),(23,'刀郎','深圳','深圳体育馆','2025-08-17 20:58:00','2025-08-18 00:58:00','看台',216,216,'280.00','2025-07-27 16:05:50'),(25,'周杰伦','广州','广州体育馆','2025-08-19 21:51:00','2025-08-20 01:51:00','VIP',426,426,'1080.00','2025-07-27 16:05:50'),(27,'刀郎','广州','广州体育馆','2025-07-29 20:07:00','2025-07-29 23:07:00','看台',295,295,'280.00','2025-07-27 16:05:50'),(34,'五月天','上海','上海体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','VIP',302,302,'1080.00','2025-07-27 16:05:50'),(35,'五月天','深圳','深圳体育馆','2025-08-03 21:45:00','2025-08-03 23:45:00','内场',420,420,'880.00','2025-07-27 16:05:50'),(43,'周杰伦','广州','广州体育馆','2025-08-26 22:00:00','2025-08-27 00:00:00','内场',360,360,'680.00','2025-07-27 16:05:50'),(44,'周杰伦','广州','广州体育馆','2025-08-02 20:41:00','2025-08-02 23:41:00','内场',399,399,'880.00','2025-07-27 16:05:50'),(46,'刀郎','深圳','深圳体育馆','2025-08-24 21:07:00','2025-08-25 01:07:00','内场',378,378,'880.00','2025-07-27 16:05:50'),(50,'五月天','北京','北京体育馆','2025-08-21 19:07:00','2025-08-21 21:07:00','内场',275,275,'880.00','2025-07-27 16:05:50'),(52,'五月天','北京','北京体育馆','2025-08-16 21:32:00','2025-08-17 00:32:00','内场',352,352,'680.00','2025-07-27 16:05:50'),(57,'五月天','广州','广州体育馆','2025-08-19 20:28:00','2025-08-20 00:28:00','内场',409,409,'880.00','2025-07-27 16:05:50'),(59,'周杰伦','深圳','深圳体育馆','2025-08-01 19:35:00','2025-08-01 21:35:00','内场',411,411,'880.00','2025-07-27 16:05:50'),(61,'刀郎','上海','上海体育馆','2025-08-25 19:37:00','2025-08-25 21:37:00','VIP',304,304,'1280.00','2025-07-27 16:05:50'),(63,'五月天','广州','广州体育馆','2025-08-06 20:54:00','2025-08-06 22:54:00','VIP',413,413,'1280.00','2025-07-27 16:05:50'),(67,'五月天','上海','上海体育馆','2025-08-16 20:08:00','2025-08-17 00:08:00','看台',382,382,'180.00','2025-07-27 16:05:50'),(69,'周杰伦','广州','广州体育馆','2025-08-15 21:36:00','2025-08-15 23:36:00','看台',449,449,'50.00','2025-07-27 16:05:50'),(70,'五月天','广州','广州体育馆','2025-08-19 21:50:00','2025-08-20 01:50:00','VIP',287,287,'1080.00','2025-07-27 16:05:50'),(71,'刀郎','深圳','深圳体育馆','2025-08-09 20:17:00','2025-08-09 22:17:00','看台',441,441,'180.00','2025-07-27 16:05:50'),(73,'周杰伦','北京','北京体育馆','2025-08-17 21:13:00','2025-08-18 00:13:00','看台',335,335,'180.00','2025-07-27 16:05:50'),(77,'张学友','北京','北京体育馆','2025-08-05 20:11:00','2025-08-05 23:11:00','VIP',251,251,'1280.00','2025-07-27 16:05:50'),(78,'刀郎','深圳','深圳体育馆','2025-08-01 21:04:00','2025-08-02 01:04:00','看台',232,232,'280.00','2025-07-27 16:05:50'),(79,'五月天','广州','广州体育馆','2025-08-04 20:35:00','2025-08-05 00:35:00','内场',253,253,'880.00','2025-07-27 16:05:50'),(80,'刀郎','上海','上海体育馆','2025-08-06 20:32:00','2025-08-07 00:32:00','VIP',489,489,'1280.00','2025-07-27 16:05:50'),(83,'张学友','上海','上海体育馆','2025-08-26 21:02:00','2025-08-27 00:00:00','内场',284,284,'880.00','2025-07-27 16:05:50'),(85,'周杰伦','深圳','深圳体育馆','2025-08-16 20:54:00','2025-08-17 00:54:00','看台',262,262,'50.00','2025-07-27 16:05:50'),(86,'周杰伦','北京','北京体育馆','2025-08-13 20:17:00','2025-08-13 22:17:00','看台',428,428,'180.00','2025-07-27 16:05:50'),(88,'五月天','广州','广州体育馆','2025-07-30 19:30:00','2025-07-30 23:30:00','看台',325,325,'480.00','2025-07-27 16:05:50'),(90,'刀郎','北京','北京体育馆','2025-08-23 20:04:00','2025-08-24 00:04:00','看台',222,222,'180.00','2025-07-27 16:05:50'),(91,'周杰伦','上海','上海体育馆','2025-08-01 21:59:00','2025-08-01 23:59:00','内场',300,300,'680.00','2025-07-27 16:05:50'),(98,'刀郎','深圳','深圳体育馆','2025-08-01 20:43:00','2025-08-02 00:43:00','看台',242,242,'50.00','2025-07-27 16:05:50'),(99,'张学友','广州','广州体育馆','2025-08-08 21:32:00','2025-08-09 01:32:00','内场',387,387,'680.00','2025-07-27 16:05:50'),(101,'五月天','上海','上海体育馆','2025-08-17 20:06:00','2025-08-18 00:06:00','VIP',445,445,'1080.00','2025-07-27 16:05:50'),(104,'张学友','广州','广州体育馆','2025-08-08 19:17:00','2025-08-08 23:17:00','VIP',459,459,'1080.00','2025-07-27 16:05:50'),(108,'周杰伦','北京','北京体育馆','2025-08-19 21:39:00','2025-08-20 01:39:00','VIP',272,272,'1080.00','2025-07-27 16:05:50'),(110,'周杰伦','深圳','深圳体育馆','2025-08-13 21:44:00','2025-08-14 00:44:00','VIP',351,351,'1080.00','2025-07-27 16:05:50'),(113,'周杰伦','深圳','深圳体育馆','2025-08-10 20:16:00','2025-08-10 23:16:00','VIP',369,369,'1280.00','2025-07-27 16:05:50'),(114,'周杰伦','北京','北京体育馆','2025-08-15 20:57:00','2025-08-15 23:57:00','看台',212,212,'480.00','2025-07-27 16:05:50'),(115,'张学友','北京','北京体育馆','2025-07-28 19:37:00','2025-07-28 21:37:00','VIP',222,222,'1280.00','2025-07-27 16:05:50'),(116,'张学友','北京','北京体育馆','2025-08-09 19:27:00','2025-08-09 23:27:00','内场',469,469,'680.00','2025-07-27 16:05:50'),(119,'张学友','北京','北京体育馆','2025-08-16 19:13:00','2025-08-16 22:13:00','内场',360,360,'680.00','2025-07-27 16:05:50'),(122,'周杰伦','深圳','深圳体育馆','2025-08-21 19:20:00','2025-08-21 21:20:00','内场',380,380,'680.00','2025-07-27 16:05:50'),(125,'刀郎','北京','北京体育馆','2025-08-11 20:33:00','2025-08-12 00:33:00','看台',490,490,'280.00','2025-07-27 16:05:50'),(130,'张学友','广州','广州体育馆','2025-07-29 20:30:00','2025-07-30 00:30:00','VIP',219,219,'1280.00','2025-07-27 16:05:50'),(131,'刀郎','上海','上海体育馆','2025-08-14 21:46:00','2025-08-14 23:46:00','VIP',475,475,'1080.00','2025-07-27 16:05:50'),(136,'周杰伦','广州','广州体育馆','2025-08-14 20:27:00','2025-08-14 22:27:00','看台',307,307,'50.00','2025-07-27 16:05:50'),(137,'刀郎','上海','上海体育馆','2025-08-03 21:28:00','2025-08-04 00:28:00','看台',294,294,'480.00','2025-07-27 16:05:50'),(139,'周杰伦','深圳','深圳体育馆','2025-08-08 19:08:00','2025-08-08 21:08:00','VIP',495,495,'1280.00','2025-07-27 16:05:50'),(141,'周杰伦','广州','广州体育馆','2025-08-03 21:38:00','2025-08-03 23:38:00','内场',210,210,'680.00','2025-07-27 16:05:50'),(144,'五月天','北京','北京体育馆','2025-08-14 22:01:00','2025-08-15 02:01:00','VIP',472,472,'1280.00','2025-07-27 16:05:50'),(149,'张学友','北京','北京体育馆','2025-07-29 22:00:00','2025-07-30 01:00:00','看台',461,461,'180.00','2025-07-27 16:05:50'),(152,'刀郎','北京','北京体育馆','2025-08-04 21:02:00','2025-08-05 00:02:00','VIP',467,467,'1280.00','2025-07-27 16:05:50'),(153,'周杰伦','深圳','深圳体育馆','2025-08-15 20:04:00','2025-08-15 22:04:00','VIP',292,292,'1280.00','2025-07-27 16:05:50'),(161,'周杰伦','北京','北京体育馆','2025-08-04 21:18:00','2025-08-04 23:18:00','看台',338,338,'280.00','2025-07-27 16:05:50'),(162,'五月天','广州','广州体育馆','2025-08-25 19:44:00','2025-08-25 21:44:00','内场',326,326,'680.00','2025-07-27 16:05:50'),(163,'张学友','上海','上海体育馆','2025-08-07 21:21:00','2025-08-08 00:21:00','VIP',400,400,'1080.00','2025-07-27 16:05:50'),(165,'张学友','深圳','深圳体育馆','2025-08-11 20:03:00','2025-08-11 22:03:00','看台',421,421,'480.00','2025-07-27 16:05:50'),(168,'周杰伦','深圳','深圳体育馆','2025-08-20 20:08:00','2025-08-20 23:08:00','VIP',236,236,'1280.00','2025-07-27 16:05:50'),(172,'刀郎','广州','广州体育馆','2025-08-06 19:09:00','2025-08-06 22:09:00','VIP',462,462,'1080.00','2025-07-27 16:05:50'),(174,'刀郎','深圳','深圳体育馆','2025-08-25 20:34:00','2025-08-25 22:34:00','看台',326,326,'180.00','2025-07-27 16:05:50'),(175,'刀郎','深圳','深圳体育馆','2025-08-26 21:35:00','2025-08-27 00:00:00','VIP',428,428,'1280.00','2025-07-27 16:05:50'),(177,'五月天','上海','上海体育馆','2025-07-29 20:39:00','2025-07-30 00:39:00','内场',232,232,'680.00','2025-07-27 16:05:50'),(179,'周杰伦','深圳','深圳体育馆','2025-08-02 20:45:00','2025-08-03 00:45:00','VIP',489,489,'1280.00','2025-07-27 16:05:50'),(180,'周杰伦','深圳','深圳体育馆','2025-07-28 19:29:00','2025-07-28 23:29:00','内场',287,287,'880.00','2025-07-27 16:05:50'),(183,'周杰伦','上海','上海体育馆','2025-08-22 20:01:00','2025-08-23 00:01:00','看台',463,463,'280.00','2025-07-27 16:05:50'),(190,'周杰伦','北京','北京体育馆','2025-08-01 21:52:00','2025-08-01 23:52:00','内场',231,231,'880.00','2025-07-27 16:05:50'),(191,'五月天','广州','广州体育馆','2025-08-05 20:13:00','2025-08-06 00:13:00','看台',352,352,'50.00','2025-07-27 16:05:50'),(199,'张学友','北京','北京体育馆','2025-08-14 20:47:00','2025-08-14 23:47:00','内场',338,338,'880.00','2025-07-27 16:05:50'),(201,'周杰伦','上海','上海体育馆','2025-08-17 19:21:00','2025-08-17 23:21:00','看台',310,310,'480.00','2025-07-27 16:05:50'),(205,'刀郎','北京','北京体育馆','2025-08-24 21:41:00','2025-08-25 00:41:00','看台',311,311,'180.00','2025-07-27 16:05:50'),(209,'张学友','广州','广州体育馆','2025-08-07 19:48:00','2025-08-07 23:48:00','看台',246,246,'180.00','2025-07-27 16:05:50'),(211,'张学友','深圳','深圳体育馆','2025-08-03 20:15:00','2025-08-03 22:15:00','看台',202,202,'280.00','2025-07-27 16:05:50'),(212,'刀郎','深圳','深圳体育馆','2025-08-25 21:53:00','2025-08-25 23:53:00','内场',300,300,'680.00','2025-07-27 16:05:50'),(215,'刀郎','北京','北京体育馆','2025-08-14 20:17:00','2025-08-14 22:17:00','看台',223,223,'180.00','2025-07-27 16:05:50'),(216,'周杰伦','深圳','深圳体育馆','2025-08-17 20:59:00','2025-08-17 22:59:00','看台',381,381,'280.00','2025-07-27 16:05:50'),(217,'周杰伦','广州','广州体育馆','2025-08-02 20:26:00','2025-08-03 00:26:00','内场',403,403,'680.00','2025-07-27 16:05:50'),(218,'刀郎','深圳','深圳体育馆','2025-07-31 19:06:00','2025-07-31 21:06:00','VIP',319,319,'1280.00','2025-07-27 16:05:50'),(221,'刀郎','广州','广州体育馆','2025-08-07 20:45:00','2025-08-07 22:45:00','VIP',465,465,'1080.00','2025-07-27 16:05:50'),(222,'五月天','深圳','深圳体育馆','2025-08-13 19:14:00','2025-08-13 22:14:00','VIP',479,479,'1280.00','2025-07-27 16:05:50'),(223,'五月天','北京','北京体育馆','2025-08-16 20:37:00','2025-08-16 23:37:00','VIP',494,494,'1080.00','2025-07-27 16:05:50'),(227,'刀郎','广州','广州体育馆','2025-07-27 21:04:00','2025-07-27 23:04:00','看台',296,296,'280.00','2025-07-27 16:05:50'),(228,'五月天','深圳','深圳体育馆','2025-08-15 20:09:00','2025-08-15 22:09:00','看台',233,233,'280.00','2025-07-27 16:05:50'),(229,'刀郎','广州','广州体育馆','2025-07-28 21:03:00','2025-07-29 00:03:00','看台',438,438,'480.00','2025-07-27 16:05:50'),(231,'五月天','北京','北京体育馆','2025-08-24 20:05:00','2025-08-25 00:05:00','看台',385,385,'50.00','2025-07-27 16:05:50'),(237,'五月天','上海','上海体育馆','2025-08-15 20:45:00','2025-08-15 23:45:00','看台',240,240,'480.00','2025-07-27 16:05:50'),(241,'刀郎','上海','上海体育馆','2025-07-31 19:54:00','2025-07-31 21:54:00','VIP',332,332,'1080.00','2025-07-27 16:05:50'),(244,'张学友','上海','上海体育馆','2025-07-31 21:52:00','2025-08-01 00:52:00','VIP',228,228,'1080.00','2025-07-27 16:05:50'),(252,'五月天','深圳','深圳体育馆','2025-08-25 21:54:00','2025-08-26 01:54:00','内场',257,257,'880.00','2025-07-27 16:05:50'),(258,'周杰伦','上海','上海体育馆','2025-08-22 19:04:00','2025-08-22 22:04:00','VIP',294,294,'1280.00','2025-07-27 16:05:50'),(259,'张学友','上海','上海体育馆','2025-08-05 21:32:00','2025-08-05 23:32:00','内场',430,430,'680.00','2025-07-27 16:05:50'),(262,'张学友','深圳','深圳体育馆','2025-08-04 21:26:00','2025-08-05 00:26:00','VIP',318,318,'1280.00','2025-07-27 16:05:50'),(266,'五月天','北京','北京体育馆','2025-08-17 21:34:00','2025-08-18 00:34:00','看台',216,216,'180.00','2025-07-27 16:05:50'),(268,'刀郎','北京','北京体育馆','2025-08-15 19:49:00','2025-08-15 21:49:00','内场',264,264,'880.00','2025-07-27 16:05:50'),(271,'刀郎','广州','广州体育馆','2025-08-17 21:02:00','2025-08-17 23:02:00','VIP',473,473,'1280.00','2025-07-27 16:05:50'),(272,'张学友','北京','北京体育馆','2025-08-04 21:37:00','2025-08-05 01:37:00','内场',272,272,'680.00','2025-07-27 16:05:50'),(276,'周杰伦','北京','北京体育馆','2025-08-17 21:22:00','2025-08-18 01:22:00','VIP',219,219,'1080.00','2025-07-27 16:05:50'),(279,'张学友','上海','上海体育馆','2025-07-29 19:14:00','2025-07-29 23:14:00','内场',256,256,'880.00','2025-07-27 16:05:50'),(283,'五月天','北京','北京体育馆','2025-08-22 20:39:00','2025-08-22 22:39:00','VIP',254,254,'1080.00','2025-07-27 16:05:50'),(285,'张学友','深圳','深圳体育馆','2025-08-07 19:59:00','2025-08-07 21:59:00','VIP',405,405,'1280.00','2025-07-27 16:05:50'),(287,'张学友','上海','上海体育馆','2025-08-18 20:47:00','2025-08-18 22:47:00','内场',317,317,'680.00','2025-07-27 16:05:50'),(288,'刀郎','广州','广州体育馆','2025-08-18 21:13:00','2025-08-19 00:13:00','看台',449,449,'50.00','2025-07-27 16:05:50'),(292,'张学友','北京','北京体育馆','2025-08-20 20:56:00','2025-08-20 23:56:00','VIP',314,314,'1080.00','2025-07-27 16:05:50'),(294,'五月天','深圳','深圳体育馆','2025-08-02 21:40:00','2025-08-03 01:40:00','看台',380,380,'180.00','2025-07-27 16:05:50'),(296,'张学友','深圳','深圳体育馆','2025-08-26 20:11:00','2025-08-26 23:11:00','内场',250,250,'880.00','2025-07-27 16:05:50'),(297,'张学友','广州','广州体育馆','2025-08-04 20:24:00','2025-08-04 22:24:00','内场',376,376,'680.00','2025-07-27 16:05:50'),(298,'刀郎','深圳','深圳体育馆','2025-08-24 20:17:00','2025-08-24 23:17:00','VIP',335,335,'1280.00','2025-07-27 16:05:50'),(299,'周杰伦','广州','广州体育馆','2025-08-06 19:55:00','2025-08-06 21:55:00','看台',224,224,'180.00','2025-07-27 16:05:50'),(306,'刀郎','北京','北京体育馆','2025-08-22 20:57:00','2025-08-22 23:57:00','VIP',488,488,'1080.00','2025-07-27 16:05:50');


UPDATE travel_rag.concert_tickets
SET
    start_time = DATE_ADD(start_time, INTERVAL DATEDIFF(CURDATE(), '2025-08-06') DAY),
    end_time = DATE_ADD(end_time, INTERVAL DATEDIFF(CURDATE(), '2025-08-06') DAY);

UPDATE travel_rag.flight_tickets
SET
    departure_time = DATE_ADD(departure_time, INTERVAL DATEDIFF(CURDATE(), '2025-08-06') DAY),
    arrival_time = DATE_ADD(arrival_time, INTERVAL DATEDIFF(CURDATE(), '2025-08-06') DAY);

UPDATE travel_rag.train_tickets
SET
    departure_time = DATE_ADD(departure_time, INTERVAL DATEDIFF(CURDATE(), '2025-08-06') DAY),
    arrival_time = DATE_ADD(arrival_time, INTERVAL DATEDIFF(CURDATE(), '2025-08-06') DAY);

UPDATE travel_rag.weather_data
SET
    fx_date = DATE_ADD(fx_date, INTERVAL DATEDIFF(CURDATE(), '2025-08-06') DAY);