air_flight, MySQL - rextester

air_flight

Insert into air_flight values('916' ,'100000','ABC AIRLINES' ,'CHENNAI ',
'HYDERABAD','19:55:00','21:00:00', 
'01:05:00 ', 40), 
('289', '100000','ABC AIRLINES','CHENNAI','KOCHI','08:40:00','09:55:00','01:15:00',
80), 
('1011','100000','ABC AIRLINES','HYDERABAD','CHENNAI','12:30:00','13:55:00',
'01:25:00',50), 
('3004','100000','ABC AIRLINES','BENGALURU','CHENNAI','09:05:00','10:25:00'
,'01:20:00',100), 
('3307','100000','ABC AIRLINES','BENGALURU','CHENNAI','18:45:00','19:45:00',
'01:00:00',40), 
('3013','100000','ABC AIRLINES','CHENNAI','BENGALURU','07:40:00','08:45:00',
'01:05:00',50), 
 
('3148','100000','ABC AIRLINES','CHENNAI','BENGALURU','20:15:00', '21:20:00',      
'01:05:00',100), 
('1265','100000','ABC AIRLINES', 'CHENNAI','HYDERABAD','21:25:00','22:55:00',
'01:30:00',100), 
('3241','100000','ABC AIRLINES', 'CHENNAI', 'KOCHI','10:40:00','12:05:00',
'01:25:00',80), 
( '3244' ,'100000','ABC AIRLINES','KOCHI','CHENNAI','21:10:00','22:40:00',
'01:30:00',50), 
('1262','100000','ABC AIRLINES','HYDERABAD','CHENNAI','06:00:00','07:20:00'
,'01:20:00',100); 
 
 
Insert into air_ticket_info values 
 
('TKT001 ', 'PFL007',    '3004',      '2013-05-02'     ,'BOOKED'), 
 
('TKT002','PFL007','3004', '2013-05-02  ','  BOOKED '), 
('TKT003' ,' PFL007', '3004','2013-05-02','BOOKED'), 
 
 
('TKT004','PFL001','1265','2013-04-29',' BOOKED '), 
('TKT005', ' PFL001 ','1011' ,'2013-05-09','BOOKED' ), 
('TKT006','PFL007',' 3148','2013-05-21','BOOKED '), 
('TKT007',' PFL007','3148',' 2013-05-21','BOOKED '), 
('TKT008','PFL003','3244','2013-05-03',' BOOKED' ), 
('TKT009',' PFL003','3244',' 2013-05-03','BOOKED' ), 
('TKT010','PFL003','3244','2013-05-03','BOOKED' ), 
('TKT011','PFL002',' 3148',' 2013-06-01',' BOOKED' ), 
('TKT012',' PFL002',' 3148',' 2013-06-01','BOOKED' ), 
('TKT013',' PFL002','3148',' 2013-06-01',' BOOKED' ), 
('TKT014',' PFL002','3148','2013-06-01','BOOKED '), 
('TKT015','PFL002','3148','2013-06-01','BOOKED '), 
('TKT016',' PFL004','1262',' 2013-05-20',' BOOKED' ), 
('TKT017','PFL004','1265',' 2013-05-29','BOOKED '), 
('TKT018',' PFL006','3244 ','2013-05-03',' BOOKED '), 
('TKT019','PFL006','3244','2013-05-03','BOOKED '), 
('TKT020','PFL006','3244','2013-05-03',' BOOKED '), 
('TKT021',' PFL006','3244','2013-05-03','BOOKED '), 
('TKT022',' PFL005','916',' 2013-05-06',' BOOKED '), 
('TKT023','PFL005','916',' 2013-05-06',' BOOKED '), 
('TKT024',' PFL005',' 1011','2013-05-09',' BOOKED' ), 
('TKT025','PFL005','1011','2013-05-09','BOOKED '), 
('TKT026',' PFL008','1011',' 2013-05-09','BOOKED'); 
 
 
Insert into air_flight_details  values ( '916',   '2013-04-28','4086.00',40), 
('916','2013-05-12','3023.00',40), 
('916','2013-05-01','4086.00',40), 
('916','2013-05-06','3603.00',38), 
 
 
('289','2013-05-06','3603.00',80), 
('289','2013-05-08','3603.00',80), 
('289','2013-05-20','3052.00',80), 
('289','2013-05-31','2773.00',80), 
('1011','2013-04-30','4614.00',50), 
('1011','2013-05-09','4131.00',46), 
('1011','2013-05-21','3580.00',50), 
('3004','2013-05-02','3603.00',97), 
('3004','2013-05-24','3052.00',100), 
('3004','2013-05-19','3304.00',100), 
('3307','2013-05-03','3603.00',40), 
('3307','2013-05-03','3304.00',40), 
('3307','2013-05-23','3304.00',40), 
('3307','2013-05-29','3305.00',40), 
('3013','2013-05-04','3603.00',50), 
('3013','2013-05-06','3603.00',50), 
('3013','2013-05-22','3052.00',50), 
('3013','2013-05-30','2773.00',50), 
('3148','2013-05-16','3052.00',100), 
('3148','2013-05-21','3052.00',98), 
('3148','2013-06-01','2773.00',95), 
('1265','2013-04-29','4086.00',99), 
('1265','2013-05-14','3052.00',100), 
('1265','2013-05-18','4086.00',100), 
('1265','2013-05-29','2773.00',99), 
('3241','2013-05-01','4086.00',80), 
('3241','2013-05-13','3052.00',80), 
('3241','2013-05-27','2773.00',80), 
('3244','2013-05-03', '3647.00',43), 
 
 
('3244','2013-05-15','3096.00',50), 
('1262', '2013-05-20','3580.00', 99), 
('1262', '2013-05-29','3309.00',100); 
 
insert into air_passenger_profile   values('PFL001',  'PFL001',   'LATHA',  'SANKAR',  '123  BROAD  CROSS 
ST,CHENNAI-48'     
,'9876543210',' LATHA@GMAIL.COM' ), 
('PFL002',' PFL002',' ARUN',' PRAKASH',' 768  2ND STREET,BENGALURU-20',    '8094564243 
','ARUN@AOL.COM' ), 
('PFL003',' PFL003 ','AMIT',' VIKARAM',' 43 5TH STREET,KOCHI-84',     '9497996990 ','AMIT@AOL.COM'),  
('PFL004',' PFL004',' AARTHI',' RAMESH',' 343 6TH STREET,HYDERABAD-76','    9595652530',' 
AARTHI@GMAIL.COM' ), 
('PFL005',' PFL005',' SIVA',' KUMAR ','125 8TH STREET,CHENNAI-46 ','   9884416986 ','SIVA@GMAIL.COM' 
), 
('PFL006', 'PFL006 ','RAMESH',' BABU',' 109 2ND CROSS ST,KOCHI-12',    '9432198760',' 
RAMESH@GMAIL.COM '), 
('PFL007', 'PFL007' ,'GAYATHRI',' RAGHU' ,'23 2ND CROSS ST,BENGALURU-12'   ,'8073245678' 
,'GAYATHRI@GMAIL.COM '), 
('PFL008', 'PFL008',' GANESH ','KANNAN', '45 3RD ST,HYDERABAD-21',   ' 9375237890' 
,'GANESH@GMAIL.COM '); 
 
insert into air_credit_card_details  values('PFL001','4312467849804008','GOLD',2,2020), 
('PFL002','4763421245304900','PLATINIUM',10,2015), 
('PFL003','4112432643784789','INSTANT',3,2014), 
('PFL004','4230412745604112','GOLD',7,2016), 
('PFL005','4122432147834003','PLATINIUM',12,2016), 
('PFL006','4227438945674009','GOLD',12,2018), 
('PFL007','4124459047784138','INSTANT',3,2015), 
('PFL008','4312411745884010','PLATINIUM',9,2017);


run \| edit \| history \| help	0