Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
air_flight
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
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);
absolute service time: 0,31 sec
fork mode
|
history
|
discussion
Database
1
information_schema
2
rextester
Tables_in_rextester
1
a
2
air_credit_card_details
3
air_flight
4
air_flight_details
5
air_passenger_profile
6
air_ticket_info
7
artikel
8
asd
9
b
10
billed
11
c
12
candrink
13
d
14
desireresult
15
epreuves
16
equipes
17
hochschule
18
item
19
jbsale_supply
20
join_ects_note
21
join_lv_teilgenommen
22
joueurs
23
matija
24
my_name
25
myview
26
note_2_3_4
27
participer
28
patient
29
personen
30
physician
31
pivot_occup
32
presidents
33
procedures
34
r1
35
recessions
36
result
37
room
38
sale
39
salestable
40
sammelbuechse
41
score_view
42
showalldata
43
sponsor
44
tablecheck
45
task3
46
treats
47
v
48
v1
49
view_bank_master
50
view_by_occup
51
view_by_occup_pivot
52
w