-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathinsert_flight.sql
11 lines (11 loc) · 1.54 KB
/
insert_flight.sql
1
2
3
4
5
6
7
8
9
10
11
INSERT INTO `flight_search` (`fname`, `fno`, `from_city`, `to_city`, `f_stops`, `f-stop_city`, `f_airtime`, `f_stoptime`, `departure_date`, `arrival_date`, `departure_time`, `arrival_time`, `e_seats_left`, `b_seats_left`, `e_price`, `b_price`, `booked_status`) VALUES
('Indigo', 'AX101', 'Delhi', 'Chennai', 0, 'NULL', 180, 0, '23-08-2018', '23-08-2018', '09:00', '12:00', 19, 10, 3500, 6500, 0),
('Indigo', 'AX111', 'Delhi', 'Chennai', 0, 'NULL', 180, 0, '24-08-2018', '24-08-2018', '09:00', '12:00', 19, 10, 3500, 6500, 0),
('Indigo', 'AX121', 'Delhi', 'Chennai', 0, 'NULL', 180, 0, '25-08-2018', '25-08-2018', '09:00', '12:00', 19, 10, 3500, 6500, 0),
('AirIndia', 'AX132', 'Delhi', 'Chennai', 0, 'NULL', 180, 0, '23-08-2018', '23-08-2018', '10:30', '13:30', 40, 20, 4000, 9500, 0),
('AirIndia', 'AX182', 'Delhi', 'Chennai', 0, 'NULL', 180, 0, '24-08-2018', '24-08-2018', '10:30', '13:30', 40, 20, 4000, 9500, 0),
('AirIndia', 'AX282', 'Delhi', 'Chennai', 0, 'NULL', 180, 0, '25-08-2018', '25-08-2018', '10:30', '13:30', 40, 20, 4000, 9500, 0),
('Indigo', 'AX303', 'Chennai', 'Delhi', 1, 'Hyderabad', 270, 60, '24-08-2018', '24-08-2018', '12:30', '18:00', 60, 10, 4100, 9000, 0),
('Indigo', 'AX136', 'Chennai', 'Delhi', 1, 'Hyderabad', 270, 60, '23-08-2018', '23-08-2018', '12:30', '18:00', 60, 10, 4100, 9000, 0),
('Indigo', 'AX169', 'Mumbai', 'Delhi', 0, 'NULL', 150, 0, '23-08-2018', '23-08-208', '10:00', '12:30', 60, 10, 4100, 9000, 0),
('AirIndia', 'AX193', 'Delhi', 'Mumbai', 0, 'NULL', 150, 0, '23-08-2018', '23-08-208', '12:00', '14:30', 60, 10, 4100, 9000, 0);