C:\Users\Asus>cd\
C:\>cd apache
C:\apache>cd mysql
C:\apache\mysql>cd bin
C:\apache\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.16-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database keretaapi;
Query OK, 1 row affected (0.29 sec)
mysql> use keretaapi;
Database changed
mysql> create table TIKETAGENT(
-> nama_agent varchar(20) not null,
-> kode_pembayaran varchar(20) not null,
-> primary key (nama_agent));
Query OK, 0 rows affected (0.02 sec)
mysql> desc TIKETAGENT;
+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| nama_agent | varchar(20) | | PRI | | |
| kode_pembayaran | varchar(20) | | | | |
+-----------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> create table penumpang(
-> id_penumpang varchar(20) NOT NULL,
-> nama_penumpang varchar(20) NOT NULL,
-> alamat varchar(20) NOT NULL,
-> no_tlpn varchar(20) NOT NULL,
-> primary key (id_penumpang));
Query OK, 0 rows affected (0.00 sec)
mysql> desc penumpang;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_penumpang | varchar(20) | | PRI | | |
| nama_penumpang | varchar(20) | | | | |
| alamat | varchar(20) | | | | |
| no_tlpn | varchar(20) | | | | |
+----------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> create table petugas(
-> id_petugas varchar(20) not null,
-> nama_petugas varchar(20) not null,
-> jabatan varchar(20) not null,
-> umur varchar(20) not null,
-> primary key (id_petugas));
Query OK, 0 rows affected (0.00 sec)
mysql> desc petugas;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_petugas | varchar(20) | | PRI | | |
| nama_petugas | varchar(20) | | | | |
| jabatan | varchar(20) | | | | |
| umur | varchar(20) | | | | |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> create table kereta(
-> id_KA varchar(30) not null,
-> Nama_KA varchar(20) not null,
-> Kelas varchar(20) not null,
-> tujuan varchar(20) not null,
-> Harga varchar(20) not null,
-> jam_tiba varchar(20) not null,
-> Jam_berangkat varchar(20) not null,
-> asal varchar(20) not null,
-> Jumlah_gerbong varchar(20) not null,
-> primary key (id_KA));
Query OK, 0 rows affected (0.00 sec)
mysql> desc kereta;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_KA | varchar(30) | | PRI | | |
| Nama_KA | varchar(20) | | | | |
| Kelas | varchar(20) | | | | |
| tujuan | varchar(20) | | | | |
| Harga | varchar(20) | | | | |
| jam_tiba | varchar(20) | | | | |
| Jam_berangkat | varchar(20) | | | | |
| asal | varchar(20) | | | | |
| Jumlah_gerbong | varchar(20) | | | | |
+----------------+-------------+------+-----+---------+-------+
9 rows in set (0.00 sec)
mysql> create table stasiun(
-> id_stasiun varchar(20) not null,
-> Nama_stasiun varchar(20) not null,
-> kelas varchar(20) not null,
-> primary key (id_stasiun));
Query OK, 0 rows affected (0.00 sec)
mysql> desc stasiun;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_stasiun | varchar(20) | | PRI | | |
| Nama_stasiun | varchar(20) | | | | |
| kelas | varchar(20) | | | | |
+--------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> create table gerbong(
-> id_gerbong varchar(20) not null,
-> id_KA varchar(20) not null,
-> kelas varchar(20) not null,
-> primary key (id_gerbong));
Query OK, 0 rows affected (0.00 sec)
mysql> desc gerbong;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_gerbong | varchar(20) | | PRI | | |
| id_KA | varchar(20) | | | | |
| kelas | varchar(20) | | | | |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> create table tiket(
-> no_reservasi varchar(20) not null,
-> id_penumpang varchar(20) not null,
-> id_petugas varchar(20) not null,
-> id_KA varchar(20) not null,
-> id_gerbong varchar(20) not null,
-> id_stasiun varchar(20) not null,
-> Nama_KA varchar(20) not null,
-> kelas varchar(20) not null,
-> no_kursi varchar(20) not null,
-> tgl_pesan date not null,
-> tgl_berangkat date not null,
-> primary key (no_reservasi));
Query OK, 0 rows affected (0.00 sec)
mysql> desc tiket;
+---------------+-------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+------------+-------+
| no_reservasi | varchar(20) | | PRI | | |
| id_penumpang | varchar(20) | | | | |
| id_petugas | varchar(20) | | | | |
| id_KA | varchar(20) | | | | |
| id_gerbong | varchar(20) | | | | |
| id_stasiun | varchar(20) | | | | |
| Nama_KA | varchar(20) | | | | |
| kelas | varchar(20) | | | | |
| no_kursi | varchar(20) | | | | |
| tgl_pesan | date | | | 0000-00-00 | |
| tgl_berangkat | date | | | 0000-00-00 | |
+---------------+-------------+------+-----+------------+-------+
11 rows in set (0.00 sec)
mysql> ALTER table penumpang
-> ADD FOREIGN KEY(id_penumpang)
-> REFERENCES frontoffice(id_penumpang);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER table petugas
-> ADD FOREIGN KEY(id_petugas)
-> REFERENCES frontoffice(id_petugas);
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER table kereta
-> ADD FOREIGN KEY(id_KA)
-> REFERENCES frontoffice(id_KA);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER table gerbong
-> ADD FOREIGN KEY(id_gerbong)
-> REFERENCES frontoffice(id_gerbong);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER table stasiun
-> ADD FOREIGN KEY(id_stasiun)
-> REFERENCES frontoffice(id_stasiun);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc tiketagent;
+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| nama_agent | varchar(20) | | PRI | | |
| kode_pembayaran | varchar(20) | | | | |
+-----------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> insert into tiketagent
-> values('Ayu','0009'),
-> ('Daniel','0008'),
-> ('Risma','00010'),
-> ('Atri','00011'),
-> ('Dina','00867'),
-> ('Nanda','0012'),
-> ('Dewa','00034'),
-> ('Rio','0034'),
-> ('Budi','0021'),
-> ('Lisa','9986');
Query OK, 10 rows affected (0.00 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from tiketagent;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Ayu | 0009 |
| Daniel | 0008 |
| Risma | 00010 |
| Atri | 00011 |
| Dina | 00867 |
| Nanda | 0012 |
| Dewa | 00034 |
| Rio | 0034 |
| Budi | 0021 |
| Lisa | 9986 |
+------------+-----------------+
10 rows in set (0.00 sec)
mysql> select nama_agent, kode_pembayaran from tiketagent;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Ayu | 0009 |
| Daniel | 0008 |
| Risma | 00010 |
| Atri | 00011 |
| Dina | 00867 |
| Nanda | 0012 |
| Dewa | 00034 |
| Rio | 0034 |
| Budi | 0021 |
| Lisa | 9986 |
+------------+-----------------+
10 rows in set (0.00 sec)
mysql> select nama_agent,kode_pembayaran from tiketagent where nama_agent='Lisa'
;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Lisa | 9986 |
+------------+-----------------+
1 row in set (0.00 sec)
mysql> select nama_agent,kode_pembayaran from tiketagent order by nama_agent;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Atri | 00011 |
| Ayu | 0009 |
| Budi | 0021 |
| Daniel | 0008 |
| Dewa | 00034 |
| Dina | 00867 |
| Lisa | 9986 |
| Nanda | 0012 |
| Rio | 0034 |
| Risma | 00010 |
+------------+-----------------+
10 rows in set (0.00 sec)
mysql> select nama_agent,kode_pembayaran from tiketagent order by nama_agent des
c;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Risma | 00010 |
| Rio | 0034 |
| Nanda | 0012 |
| Lisa | 9986 |
| Dina | 00867 |
| Dewa | 00034 |
| Daniel | 0008 |
| Budi | 0021 |
| Ayu | 0009 |
| Atri | 00011 |
+------------+-----------------+
10 rows in set (0.00 sec)
mysql> select nama_agent,kode_pembayaran from tiketagent order by nama_agent lim
it 0,3;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Atri | 00011 |
| Ayu | 0009 |
| Budi | 0021 |
+------------+-----------------+
3 rows in set (0.00 sec)
mysql> select count(*) from tiketagent;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc penumpang;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_penumpang | varchar(20) | | PRI | | |
| nama_penumpang | varchar(20) | | | | |
| alamat | varchar(20) | | | | |
| no_tlpn | varchar(20) | | | | |
+----------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> insert into penumpang
-> values('001','ayu','jln.berdikary','00909090008'),
-> ('002','Daniel','jln.sigunggung','0008989977789'),
-> ('003','Risma','jln.merdeka','0990945686946'),
-> ('098','Atri','Jln.Cendrawasi','012458742455'),
-> ('099','Dina','jln.kampus','081365987541'),
-> ('453','Nanda','jln.kulim','08124578975'),
-> ('555','Dewa','jln.imam','085824675555'),
-> ('898','Rio','jln.berdikari','012458678787'),
-> ('685','Budi','jln.soekarno','54654378543'),
-> ('569','Lisa','jln.Palas','564876345865');
Query OK, 10 rows affected (0.00 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from penumpang;
+--------------+----------------+----------------+---------------+
| id_penumpang | nama_penumpang | alamat | no_tlpn |
+--------------+----------------+----------------+---------------+
| 001 | ayu | jln.berdikary | 00909090008 |
| 002 | Daniel | jln.sigunggung | 0008989977789 |
| 003 | Risma | jln.merdeka | 0990945686946 |
| 098 | Atri | Jln.Cendrawasi | 012458742455 |
| 099 | Dina | jln.kampus | 081365987541 |
| 453 | Nanda | jln.kulim | 08124578975 |
| 555 | Dewa | jln.imam | 085824675555 |
| 898 | Rio | jln.berdikari | 012458678787 |
| 685 | Budi | jln.soekarno | 54654378543 |
| 569 | Lisa | jln.Palas | 564876345865 |
+--------------+----------------+----------------+---------------+
10 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang from penumpang;
+--------------+----------------+
| id_penumpang | nama_penumpang |
+--------------+----------------+
| 001 | ayu |
| 002 | Daniel |
| 003 | Risma |
| 098 | Atri |
| 099 | Dina |
| 453 | Nanda |
| 555 | Dewa |
| 898 | Rio |
| 685 | Budi |
| 569 | Lisa |
+--------------+----------------+
10 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang,alamat from penumpang where id_penumpa
ng='453';
+--------------+----------------+-----------+
| id_penumpang | nama_penumpang | alamat |
+--------------+----------------+-----------+
| 453 | Nanda | jln.kulim |
+--------------+----------------+-----------+
1 row in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang,no_tlpn from penumpang where no_tlpn
like '%08%';
+--------------+----------------+---------------+
| id_penumpang | nama_penumpang | no_tlpn |
+--------------+----------------+---------------+
| 001 | ayu | 00909090008 |
| 002 | Daniel | 0008989977789 |
| 099 | Dina | 081365987541 |
| 453 | Nanda | 08124578975 |
| 555 | Dewa | 085824675555 |
+--------------+----------------+---------------+
5 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang,alamat,no_tlpn from penumpang where al
amat='kulim'&& no_tlpn like '%08';
Empty set (0.00 sec)
mysql> select id_penumpang,nama_penumpang from penumpang order by nama_penumpang
;
+--------------+----------------+
| id_penumpang | nama_penumpang |
+--------------+----------------+
| 098 | Atri |
| 001 | ayu |
| 685 | Budi |
| 002 | Daniel |
| 555 | Dewa |
| 099 | Dina |
| 569 | Lisa |
| 453 | Nanda |
| 898 | Rio |
| 003 | Risma |
+--------------+----------------+
10 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang from penumpang order by nama_penumpang
desc;
+--------------+----------------+
| id_penumpang | nama_penumpang |
+--------------+----------------+
| 003 | Risma |
| 898 | Rio |
| 453 | Nanda |
| 569 | Lisa |
| 099 | Dina |
| 555 | Dewa |
| 002 | Daniel |
| 685 | Budi |
| 001 | ayu |
| 098 | Atri |
+--------------+----------------+
10 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang from penumpang order by nama_penumpang
limit 0,3;
+--------------+----------------+
| id_penumpang | nama_penumpang |
+--------------+----------------+
| 098 | Atri |
| 001 | ayu |
| 685 | Budi |
+--------------+----------------+
3 rows in set (0.00 sec)
mysql> select count(*) from penumpang;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc petugas;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_petugas | varchar(20) | | PRI | | |
| nama_petugas | varchar(20) | | | | |
| jabatan | varchar(20) | | | | |
| umur | varchar(20) | | | | |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> insert into petugas
-> values('01','risma','sekretaris','50'),
-> ('02','ayu','marketing','50'),
-> ('03','rika','bendahara','40'),
-> ('04','budi','parkir','55'),
-> ('05','bambang','supir','20'),
-> ('99','rita','manager','30'),
-> ('88','rio','kernet','60'),
-> ('76','dimas','direktur','22'),
-> ('22','andri ','OB','30'),
-> ('10','Gilang','OB1','50'),
mysql> select* from petugas;
+------------+--------------+------------+------+
| id_petugas | nama_petugas | jabatan | umur |
+------------+--------------+------------+------+
| 01 | risma | sekretaris | 50 |
| 02 | ayu | marketing | 50 |
| 03 | rika | bendahara | 40 |
| 04 | budi | parkir | 55 |
| 05 | bambang | supir | 20 |
| 99 | rita | manager | 30 |
| 88 | rio | kernet | 60 |
| 76 | dimas | direktur | 22 |
| 22 | andri | OB | 30 |
| 10 | Gilang | OB1 | 50 |
+------------+--------------+------------+------+
10 rows in set (0.00 sec)
mysql> select id_petugas,nama_petugas from petugas;
+------------+--------------+
| id_petugas | nama_petugas |
+------------+--------------+
| 01 | risma |
| 02 | ayu |
| 03 | rika |
| 04 | budi |
| 05 | bambang |
| 99 | rita |
| 88 | rio |
| 76 | dimas |
| 22 | andri |
| 10 | Gilang |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_petugas,nama_petugas,jabatan from petugas where id_petugas='99'
;
+------------+--------------+---------+
| id_petugas | nama_petugas | jabatan |
+------------+--------------+---------+
| 99 | rita | manager |
+------------+--------------+---------+
1 row in set (0.00 sec)
mysql> select id_petugas,nama_petugas,umur from petugas where umur like '%50%';
+------------+--------------+------+
| id_petugas | nama_petugas | umur |
+------------+--------------+------+
| 01 | risma | 50 |
| 02 | ayu | 50 |
| 10 | Gilang | 50 |
+------------+--------------+------+
3 rows in set (0.00 sec)
mysql> select id_petugas,nama_petugas,jabatan,umur from petugas where jabatan='s
upir'&&umur like '%20';
+------------+--------------+---------+------+
| id_petugas | nama_petugas | jabatan | umur |
+------------+--------------+---------+------+
| 05 | bambang | supir | 20 |
+------------+--------------+---------+------+
1 row in set (0.00 sec)
mysql> select id_petugas, nama_petugas from petugas order by nama_petugas;
+------------+--------------+
| id_petugas | nama_petugas |
+------------+--------------+
| 22 | andri |
| 02 | ayu |
| 05 | bambang |
| 04 | budi |
| 76 | dimas |
| 10 | Gilang |
| 03 | rika |
| 88 | rio |
| 01 | risma |
| 99 | rita |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_petugas, nama_petugas from petugas order by nama_petugas desc;
+------------+--------------+
| id_petugas | nama_petugas |
+------------+--------------+
| 99 | rita |
| 01 | risma |
| 88 | rio |
| 03 | rika |
| 10 | Gilang |
| 76 | dimas |
| 04 | budi |
| 05 | bambang |
| 02 | ayu |
| 22 | andri |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_petugas,nama_petugas from petugas order by nama_petugas limit 0
,3;
+------------+--------------+
| id_petugas | nama_petugas |
+------------+--------------+
| 22 | andri |
| 02 | ayu |
| 05 | bambang |
+------------+--------------+
3 rows in set (0.00 sec)
mysql> select count(*) from petugas;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc kereta;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_KA | varchar(30) | NO | PRI | | |
| Nama_KA | varchar(20) | NO | | | |
| Kelas | varchar(20) | NO | | | |
| tujuan | varchar(20) | NO | | | |
| Harga | varchar(20) | NO | | | |
| jam_tiba | varchar(20) | NO | | | |
| Jam_berangkat | varchar(20) | NO | | | |
| asal | varchar(20) | NO | | | |
| Jumlah_gerbong | varchar(20) | NO | | | |
+----------------+-------------+------+-----+---------+-------+
9 rows in set (0.10 sec)
mysql> insert into kereta
-> values('201','Logawa','Eksekutif','Purwokerto','50.000','15.00','10.00','Jember','10'),
-> ('202','Kertajaya','Bisnis','Surabaya','55.000','14.00','10.00','Tanjungpriok','11'),
-> ('203','Brantas','Ekonomi','Kediri','40.000','14.20','10.20','Pasarsenen','12'),
-> ('204','Kahuripan','Ekonomi AC','Tegal','50.000','14.50','10.40','Banyuwangi','13'),
-> ('205','Kahuripan','Ekonomi','Kutoarjo','55.000','15.10','10.55','Jakarta','14'),
-> ('206','Bengawan','Bisnis','Purwosari','65.000','15.20','11.00','Malang','15'),
-> ('207','Progo','Eksekutif','Lempuyangan','40.000','15.30','11.20','Tegal','16'),
-> ('208','Pasundan','Eksekutif','Malang','45.000','15.40','11.40','Jember','17'),
-> ('209','Sri Tanjung','Bisnis','Jakarta','60.000','15.50','11.45','Semarang','18'),
-> ('2010','Matarmaja','Ekonomi AC','Jogyakarta','55.000','16.00','11.50','Malang','19');
Query OK, 10 rows affected (0.64 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from kereta;
+-------+-------------+------------+-------------+--------+----------+----------
-----+--------------+----------------+
| id_KA | Nama_KA | Kelas | tujuan | Harga | jam_tiba | Jam_beran
gkat | asal | Jumlah_gerbong |
+-------+-------------+------------+-------------+--------+----------+----------
-----+--------------+----------------+
| 201 | Logawa | Eksekutif | Purwokerto | 50.000 | 15.00 | 10.00
| Jember | 10 |
| 202 | Kertajaya | Bisnis | Surabaya | 55.000 | 14.00 | 10.00
| Tanjungpriok | 11 |
| 203 | Brantas | Ekonomi | Kediri | 40.000 | 14.20 | 10.20
| Pasarsenen | 12 |
| 204 | Kahuripan | Ekonomi AC | Tegal | 50.000 | 14.50 | 10.40
| Banyuwangi | 13 |
| 205 | Kahuripan | Ekonomi | Kutoarjo | 55.000 | 15.10 | 10.55
| Jakarta | 14 |
| 206 | Bengawan | Bisnis | Purwosari | 65.000 | 15.20 | 11.00
| Malang | 15 |
| 207 | Progo | Eksekutif | Lempuyangan | 40.000 | 15.30 | 11.20
| Tegal | 16 |
| 208 | Pasundan | Eksekutif | Malang | 45.000 | 15.40 | 11.40
| Jember | 17 |
| 209 | Sri Tanjung | Bisnis | Jakarta | 60.000 | 15.50 | 11.45
| Semarang | 18 |
| 2010 | Matarmaja | Ekonomi AC | Jogyakarta | 55.000 | 16.00 | 11.50
mysql> select id_KA,Nama_KA,tujuan from kereta;
+-------+-------------+-------------+
| id_KA | Nama_KA | tujuan |
+-------+-------------+-------------+
| 201 | Logawa | Purwokerto |
| 202 | Kertajaya | Surabaya |
| 203 | Brantas | Kediri |
| 204 | Kahuripan | Tegal |
| 205 | Kahuripan | Kutoarjo |
| 206 | Bengawan | Purwosari |
| 207 | Progo | Lempuyangan |
| 208 | Pasundan | Malang |
| 209 | Sri Tanjung | Jakarta |
| 2010 | Matarmaja | Jogyakarta |
+-------+-------------+-------------+
10 rows in set (0.00 sec)
mysql> select id_KA,Nama_KA,Kelas from kereta where id_KA='206';
+-------+----------+--------+
| id_KA | Nama_KA | Kelas |
+-------+----------+--------+
| 206 | Bengawan | Bisnis |
+-------+----------+--------+
1 row in set (0.00 sec)
mysql> select id_KA,Nama_KA,Harga from kereta where Harga like '%50.000%';
+-------+-----------+--------+
| id_KA | Nama_KA | Harga |
+-------+-----------+--------+
| 201 | Logawa | 50.000 |
| 204 | Kahuripan | 50.000 |
+-------+-----------+--------+
2 rows in set (0.00 sec)
mysql> select id_KA,Nama_KA,tujuan,Harga from kereta where tujuan='Tegal'&&Harga
like '%50.000';
+-------+-----------+--------+--------+
| id_KA | Nama_KA | tujuan | Harga |
+-------+-----------+--------+--------+
| 204 | Kahuripan | Tegal | 50.000 |
+-------+-----------+--------+--------+
1 row in set (0.00 sec)
mysql> select id_KA,Nama_KA from kereta order by Nama_KA;
+-------+-------------+
| id_KA | Nama_KA |
+-------+-------------+
| 206 | Bengawan |
| 203 | Brantas |
| 204 | Kahuripan |
| 205 | Kahuripan |
| 202 | Kertajaya |
| 201 | Logawa |
| 2010 | Matarmaja |
| 208 | Pasundan |
| 207 | Progo |
| 209 | Sri Tanjung |
+-------+-------------+
10 rows in set (0.00 sec)
mysql> select id_KA,Nama_KA from kereta order by Nama_KA desc;
+-------+-------------+
| id_KA | Nama_KA |
+-------+-------------+
| 209 | Sri Tanjung |
| 207 | Progo |
| 208 | Pasundan |
| 2010 | Matarmaja |
| 201 | Logawa |
| 202 | Kertajaya |
| 205 | Kahuripan |
| 204 | Kahuripan |
| 203 | Brantas |
| 206 | Bengawan |
+-------+-------------+
10 rows in set (0.00 sec)
mysql> select id_KA,Nama_KA from kereta order by Nama_KA limit 0,3;
+-------+-----------+
| id_KA | Nama_KA |
+-------+-----------+
| 206 | Bengawan |
| 203 | Brantas |
| 204 | Kahuripan |
+-------+-----------+
3 rows in set (0.00 sec)
mysql> select count(*) from kereta;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc stasiun;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_stasiun | varchar(20) | NO | PRI | | |
| Nama_stasiun | varchar(20) | NO | | | |
| kelas | varchar(20) | NO | | | |
+--------------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)
mysql> select* from stasiun;
+------------+--------------+------------+
| id_stasiun | Nama_stasiun | kelas |
+------------+--------------+------------+
| 121 | Gresik | Bisnis |
| 120 | Depok | Ekonomi |
| 119 | Cibitung | Eksekutif |
| 118 | Bekasi | Bisnis |
| 117 | Baturaja | Eksekutif |
| 112 | Ancol | Eksekutif |
| 113 | Angke | Ekonomi AC |
| 114 | Bogor | Ekonomi |
| 115 | Banjar | Eksekutif |
| 116 | Bandung | Ekonomi AC |
+------------+--------------+------------+
10 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun from stasiun;
+------------+--------------+
| id_stasiun | Nama_stasiun |
+------------+--------------+
| 121 | Gresik |
| 120 | Depok |
| 119 | Cibitung |
| 118 | Bekasi |
| 117 | Baturaja |
| 112 | Ancol |
| 113 | Angke |
| 114 | Bogor |
| 115 | Banjar |
| 116 | Bandung |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun,kelas from stasiun where id_stasiun='112';
+------------+--------------+-----------+
| id_stasiun | Nama_stasiun | kelas |
+------------+--------------+-----------+
| 112 | Ancol | Eksekutif |
+------------+--------------+-----------+
1 row in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun,kelas from stasiun where kelas like '%Ekon
omi%';
+------------+--------------+------------+
| id_stasiun | Nama_stasiun | kelas |
+------------+--------------+------------+
| 113 | Angke | Ekonomi AC |
| 114 | Bogor | Ekonomi |
| 116 | Bandung | Ekonomi AC |
+------------+--------------+------------+
3 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun,kelas from stasiun where Nama_stasiun='Bog
or'&& kelas like '%Ekonomi';
+------------+--------------+---------+
| id_stasiun | Nama_stasiun | kelas |
+------------+--------------+---------+
| 114 | Bogor | Ekonomi |
+------------+--------------+---------+
1 row in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun from stasiun order by Nama_stasiun;
+------------+--------------+
| id_stasiun | Nama_stasiun |
+------------+--------------+
| 121 | Gresik |
| 120 | Depok |
| 119 | Cibitung |
| 118 | Bekasi |
| 117 | Baturaja |
| 112 | Ancol |
| 113 | Angke |
| 114 | Bogor |
| 115 | Banjar |
| 116 | Bandung |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun from stasiun order by Nama_stasiun desc;
+------------+--------------+
| id_stasiun | Nama_stasiun |
+------------+--------------+
| 121 | Gresik |
| 120 | Depok |
| 119 | Cibitung |
| 115 | Banjar |
| 116 | Bandung |
| 114 | Bogor |
| 118 | Bekasi |
| 117 | Baturaja |
| 113 | Angke |
| 112 | Ancol |
+------------+--------------+
15 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun from stasiun order by Nama_stasiun limit 0
,3;
+------------+--------------+
| id_stasiun | Nama_stasiun |
+------------+--------------+
| 112 | Ancol |
| 113 | Angke |
| 11 | Bali |
+------------+--------------+
3 rows in set (0.00 sec)
mysql> select count(*) from stasiun;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc gerbong;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_gerbong | varchar(20) | NO | PRI | | |
| id_KA | varchar(20) | NO | | | |
| kelas | varchar(20) | NO | | | |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.04 sec)
mysql> insert into gerbong
-> values('303','201','Eksekutif'),
-> ('304','202','Ekonomi'),
-> ('305','203','Bisnis'),
-> ('306','204','Ekonomi'),
-> ('307','205','Eksekutif'),
-> ('308','206','Ekonomi AC'),
-> ('309','207','Ekonomi AC'),
-> ('3010','208','Ekonomi'),
-> ('3011','209','Bisnis'),
-> ('3012','2010','Eksekutif');
Query OK, 10 rows affected (0.06 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from gerbong;
+------------+-------+------------+
| id_gerbong | id_KA | kelas |
+------------+-------+------------+
| 303 | 201 | Eksekutif |
| 304 | 202 | Ekonomi |
| 305 | 203 | Bisnis |
| 306 | 204 | Ekonomi |
| 307 | 205 | Eksekutif |
| 308 | 206 | Ekonomi AC |
| 309 | 207 | Ekonomi AC |
| 3010 | 208 | Ekonomi |
| 3011 | 209 | Bisnis |
| 3012 | 2010 | Eksekutif |
+------------+-------+------------+
10 rows in set (0.00 sec)
mysql> select id_gerbong,id_KA from gerbong;
+------------+-------+
| id_gerbong | id_KA |
+------------+-------+
| 303 | 201 |
| 304 | 202 |
| 305 | 203 |
| 306 | 204 |
| 307 | 205 |
| 308 | 206 |
| 309 | 207 |
| 3010 | 208 |
| 3011 | 209 |
| 3012 | 2010 |
+------------+-------+
10 rows in set (0.00 sec)
mysql> select id_gerbong,id_KA,kelas from gerbong where id_gerbong='304';
+------------+-------+---------+
| id_gerbong | id_KA | kelas |
+------------+-------+---------+
| 304 | 202 | Ekonomi |
+------------+-------+---------+
1 row in set (0.00 sec)
mysql> select id_gerbong,id_KA kelas from gerbong where kelas like '%Ekonomi%';
+------------+-------+
| id_gerbong | kelas |
+------------+-------+
| 304 | 202 |
| 306 | 204 |
| 308 | 206 |
| 309 | 207 |
| 3010 | 208 |
+------------+-------+
5 rows in set (0.03 sec)
mysql> select id_gerbong,id_KA,kelas from gerbong where id_KA='202'&& kelas like
'%Ekonomi';
+------------+-------+---------+
| id_gerbong | id_KA | kelas |
+------------+-------+---------+
| 304 | 202 | Ekonomi |
+------------+-------+---------+
1 row in set (0.00 sec)
mysql> select id_gerbong,id_KA,kelas from gerbong order by id_KA;
+------------+-------+------------+
| id_gerbong | id_KA | kelas |
+------------+-------+------------+
| 303 | 201 | Eksekutif |
| 3012 | 2010 | Eksekutif |
| 304 | 202 | Ekonomi |
| 305 | 203 | Bisnis |
| 306 | 204 | Ekonomi |
| 307 | 205 | Eksekutif |
| 308 | 206 | Ekonomi AC |
| 309 | 207 | Ekonomi AC |
| 3010 | 208 | Ekonomi |
| 3011 | 209 | Bisnis |
+------------+-------+------------+
10 rows in set (0.00 sec)
mysql> select id_gerbong,id_KA from gerbong order by id_KA desc;
+------------+-------+
| id_gerbong | id_KA |
+------------+-------+
| 3011 | 209 |
| 3010 | 208 |
| 309 | 207 |
| 308 | 206 |
| 307 | 205 |
| 306 | 204 |
| 305 | 203 |
| 304 | 202 |
| 3012 | 2010 |
| 303 | 201 |
+------------+-------+
10 rows in set (0.00 sec)
mysql> select id_gerbong,id_KA from gerbong order by id_KA limit 0,3;
+------------+-------+
| id_gerbong | id_KA |
+------------+-------+
| 303 | 201 |
| 3012 | 2010 |
| 304 | 202 |
+------------+-------+
3 rows in set (0.00 sec)
mysql> select count(*) from gerbong;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc tiket;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| no_reservasi | varchar(20) | NO | PRI | | |
| id_penumpang | varchar(20) | NO | | | |
| id_petugas | varchar(20) | NO | | | |
| id_KA | varchar(20) | NO | | | |
| id_gerbong | varchar(20) | NO | | | |
| id_stasiun | varchar(20) | NO | | | |
| Nama_KA | varchar(20) | NO | | | |
| kelas | varchar(20) | NO | | | |
| no_kursi | varchar(20) | NO | | | |
| tgl_pesan | date | NO | | | |
| tgl_berangkat | date | NO | | | |
+---------------+-------------+------+-----+---------+-------+
11 rows in set (0.11 sec)
mysql> insert into tiket
-> values('40','020','001','201','303','112','Logawa','Eksekutif','1','2016-
04-10','2016-04-20'),
-> ('45','021','002','202','304','113','Kertajaya','Bisnis','2','2016-04-11'
,'2016-04-21'),
-> ('50','022','003','203','305','114','Brantas','Ekonomi','3','2016-04-12',
'2016-04-22'),
-> ('55','023','004','204','306','115','Kahuripan','Ekonomi AC','4','2016-04
-13','2016-04-23'),
-> ('60','024','005','205','307','116','Kahuripan','Ekonomi','5','2016-04-14
','2016-04-24'),
-> ('70','025','006','206','308','117','Bengawan','Bisnis','6','2016-04-15',
'2016-04-25'),
-> ('75','026','007','207','309','118','Progo','Eksekutif','7','2016-04-16',
'2016-04-26'),
-> ('80','027','008','208','3010','119','Pasundan','Eksekutif','8','2016-04-
17','2016-04-26'),
-> ('85','028','009','209','3011','120','Sri Tanjung','Bisnis','9','2016-04-
18','2016-04-23'),
-> ('90','029','010','2010','3012','121','Matarmaja','Ekonomi AC','10','2016
-04-19','2016-04-22');
Query OK, 10 rows affected (0.00 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from tiket;
+--------------+--------------+------------+-------+------------+------------+--
-----------+------------+----------+------------+---------------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun | N
ama_KA | kelas | no_kursi | tgl_pesan | tgl_berangkat |
+--------------+--------------+------------+-------+------------+------------+--
-----------+------------+----------+------------+---------------+
| 0102 | 020 | 001 | 201 | 303 | 112 | L
ogawa | Eksekutif | 1 | 2016-04-10 | 2016-04-20 |
| 01022 | 020 | 001 | 201 | 303 | 112 | L
ogawa | Eksekutif | 1 | 2016-04-10 | 2016-04-20 |
| 01033 | 021 | 002 | 202 | 304 | 113 | K
ertajaya | Bisnis | 2 | 2016-04-11 | 2016-04-21 |
| 40 | 020 | 001 | 201 | 303 | 112 | L
ogawa | Eksekutif | 1 | 2016-04-10 | 2016-04-20 |
| 45 | 021 | 002 | 202 | 304 | 113 | K
ertajaya | Bisnis | 2 | 2016-04-11 | 2016-04-21 |
| 50 | 022 | 003 | 203 | 305 | 114 | B
rantas | Ekonomi | 3 | 2016-04-12 | 2016-04-22 |
| 55 | 023 | 004 | 204 | 306 | 115 | K
ahuripan | Ekonomi AC | 4 | 2016-04-13 | 2016-04-23 |
| 60 | 024 | 005 | 205 | 307 | 116 | K
ahuripan | Ekonomi | 5 | 2016-04-14 | 2016-04-24 |
| 70 | 025 | 006 | 206 | 308 | 117 | B
engawan | Bisnis | 6 | 2016-04-15 | 2016-04-25 |
| 75 | 026 | 007 | 207 | 309 | 118 | P
rogo | Eksekutif | 7 | 2016-04-16 | 2016-04-26 |
| 80 | 027 | 008 | 208 | 3010 | 119 | P
asundan | Eksekutif | 8 | 2016-04-17 | 2016-04-26 |
| 85 | 028 | 009 | 209 | 3011 | 120 | S
ri Tanjung | Bisnis | 9 | 2016-04-18 | 2016-04-23 |
| 90 | 029 | 010 | 2010 | 3012 | 121 | M
atarmaja | Ekonomi AC | 10 | 2016-04-19 | 2016-04-22 |
+--------------+--------------+------------+-------+------------+------------+--
-----------+------------+----------+------------+---------------+
10 rows in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun f
rom tiket;
+--------------+--------------+------------+-------+------------+------------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun |
+--------------+--------------+------------+-------+------------+------------+
| 40 | 020 | 001 | 201 | 303 | 112 |
| 45 | 021 | 002 | 202 | 304 | 113 |
| 50 | 022 | 003 | 203 | 305 | 114 |
| 55 | 023 | 004 | 204 | 306 | 115 |
| 60 | 024 | 005 | 205 | 307 | 116 |
| 70 | 025 | 006 | 206 | 308 | 117 |
| 75 | 026 | 007 | 207 | 309 | 118 |
| 80 | 027 | 008 | 208 | 3010 | 119 |
| 85 | 028 | 009 | 209 | 3011 | 120 |
| 90 | 029 | 010 | 2010 | 3012 | 121 |
+--------------+--------------+------------+-------+------------+------------+
10 rows in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun,N
ama_KA from tiket where no_reservasi='70';
+--------------+--------------+------------+-------+------------+------------+--
--------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun | N
ama_KA |
+--------------+--------------+------------+-------+------------+------------+--
--------+
| 70 | 025 | 006 | 206 | 308 | 117 | B
engawan |
+--------------+--------------+------------+-------+------------+------------+--
--------+
1 row in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun,n
o_kursi from tiket where no_kursi like '%6%';
+--------------+--------------+------------+-------+------------+------------+--
--------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun | n
o_kursi |
+--------------+--------------+------------+-------+------------+------------+--
--------+
| 70 | 025 | 006 | 206 | 308 | 117 | 6
|
+--------------+--------------+------------+-------+------------+------------+--
--------+
1 row in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun,N
ama_KA,no_kursi from tiket where Nama_KA='Kahuripan'&& no_kursi like '%5';
+--------------+--------------+------------+-------+------------+------------+--
---------+----------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun | N
ama_KA | no_kursi |
+--------------+--------------+------------+-------+------------+------------+--
---------+----------+
| 60 | 024 | 005 | 205 | 307 | 116 | K
ahuripan | 5 |
+--------------+--------------+------------+-------+------------+------------+--
---------+----------+
1 row in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun f
rom tiket order by id_stasiun;
+--------------+--------------+------------+-------+------------+------------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun |
+--------------+--------------+------------+-------+------------+------------+
| 40 | 020 | 001 | 201 | 303 | 112 |
| 45 | 021 | 002 | 202 | 304 | 113 |
| 50 | 022 | 003 | 203 | 305 | 114 |
| 55 | 023 | 004 | 204 | 306 | 115 |
| 60 | 024 | 005 | 205 | 307 | 116 |
| 70 | 025 | 006 | 206 | 308 | 117 |
| 75 | 026 | 007 | 207 | 309 | 118 |
| 80 | 027 | 008 | 208 | 3010 | 119 |
| 85 | 028 | 009 | 209 | 3011 | 120 |
| 90 | 029 | 010 | 2010 | 3012 | 121 |
+--------------+--------------+------------+-------+------------+------------+
10 rows in set (0.01 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun
from tiket order by id_stasiun desc;
+--------------+--------------+------------+-------+------------+------------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun |
+--------------+--------------+------------+-------+------------+------------+
| 90 | 029 | 010 | 2010 | 3012 | 121 |
| 85 | 028 | 009 | 209 | 3011 | 120 |
| 80 | 027 | 008 | 208 | 3010 | 119 |
| 75 | 026 | 007 | 207 | 309 | 118 |
| 70 | 025 | 006 | 206 | 308 | 117 |
| 60 | 024 | 005 | 205 | 307 | 116 |
| 55 | 023 | 004 | 204 | 306 | 115 |
| 50 | 022 | 003 | 203 | 305 | 114 |
| 45 | 021 | 002 | 202 | 304 | 113 |
| 40 | 020 | 001 | 201 | 303 | 112 |
+--------------+--------------+------------+-------+------------+------------+
10 rows in set (0.00 sec)
mysql> select count(*) from tiket;
+----------+
| count(*) |
+----------+
| 13 |
+----------+
1 row in set (0.00 sec)
C:\>cd apache
C:\apache>cd mysql
C:\apache\mysql>cd bin
C:\apache\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.16-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database keretaapi;
Query OK, 1 row affected (0.29 sec)
mysql> use keretaapi;
Database changed
mysql> create table TIKETAGENT(
-> nama_agent varchar(20) not null,
-> kode_pembayaran varchar(20) not null,
-> primary key (nama_agent));
Query OK, 0 rows affected (0.02 sec)
mysql> desc TIKETAGENT;
+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| nama_agent | varchar(20) | | PRI | | |
| kode_pembayaran | varchar(20) | | | | |
+-----------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> create table penumpang(
-> id_penumpang varchar(20) NOT NULL,
-> nama_penumpang varchar(20) NOT NULL,
-> alamat varchar(20) NOT NULL,
-> no_tlpn varchar(20) NOT NULL,
-> primary key (id_penumpang));
Query OK, 0 rows affected (0.00 sec)
mysql> desc penumpang;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_penumpang | varchar(20) | | PRI | | |
| nama_penumpang | varchar(20) | | | | |
| alamat | varchar(20) | | | | |
| no_tlpn | varchar(20) | | | | |
+----------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> create table petugas(
-> id_petugas varchar(20) not null,
-> nama_petugas varchar(20) not null,
-> jabatan varchar(20) not null,
-> umur varchar(20) not null,
-> primary key (id_petugas));
Query OK, 0 rows affected (0.00 sec)
mysql> desc petugas;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_petugas | varchar(20) | | PRI | | |
| nama_petugas | varchar(20) | | | | |
| jabatan | varchar(20) | | | | |
| umur | varchar(20) | | | | |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> create table kereta(
-> id_KA varchar(30) not null,
-> Nama_KA varchar(20) not null,
-> Kelas varchar(20) not null,
-> tujuan varchar(20) not null,
-> Harga varchar(20) not null,
-> jam_tiba varchar(20) not null,
-> Jam_berangkat varchar(20) not null,
-> asal varchar(20) not null,
-> Jumlah_gerbong varchar(20) not null,
-> primary key (id_KA));
Query OK, 0 rows affected (0.00 sec)
mysql> desc kereta;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_KA | varchar(30) | | PRI | | |
| Nama_KA | varchar(20) | | | | |
| Kelas | varchar(20) | | | | |
| tujuan | varchar(20) | | | | |
| Harga | varchar(20) | | | | |
| jam_tiba | varchar(20) | | | | |
| Jam_berangkat | varchar(20) | | | | |
| asal | varchar(20) | | | | |
| Jumlah_gerbong | varchar(20) | | | | |
+----------------+-------------+------+-----+---------+-------+
9 rows in set (0.00 sec)
mysql> create table stasiun(
-> id_stasiun varchar(20) not null,
-> Nama_stasiun varchar(20) not null,
-> kelas varchar(20) not null,
-> primary key (id_stasiun));
Query OK, 0 rows affected (0.00 sec)
mysql> desc stasiun;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_stasiun | varchar(20) | | PRI | | |
| Nama_stasiun | varchar(20) | | | | |
| kelas | varchar(20) | | | | |
+--------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> create table gerbong(
-> id_gerbong varchar(20) not null,
-> id_KA varchar(20) not null,
-> kelas varchar(20) not null,
-> primary key (id_gerbong));
Query OK, 0 rows affected (0.00 sec)
mysql> desc gerbong;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_gerbong | varchar(20) | | PRI | | |
| id_KA | varchar(20) | | | | |
| kelas | varchar(20) | | | | |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> create table tiket(
-> no_reservasi varchar(20) not null,
-> id_penumpang varchar(20) not null,
-> id_petugas varchar(20) not null,
-> id_KA varchar(20) not null,
-> id_gerbong varchar(20) not null,
-> id_stasiun varchar(20) not null,
-> Nama_KA varchar(20) not null,
-> kelas varchar(20) not null,
-> no_kursi varchar(20) not null,
-> tgl_pesan date not null,
-> tgl_berangkat date not null,
-> primary key (no_reservasi));
Query OK, 0 rows affected (0.00 sec)
mysql> desc tiket;
+---------------+-------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+------------+-------+
| no_reservasi | varchar(20) | | PRI | | |
| id_penumpang | varchar(20) | | | | |
| id_petugas | varchar(20) | | | | |
| id_KA | varchar(20) | | | | |
| id_gerbong | varchar(20) | | | | |
| id_stasiun | varchar(20) | | | | |
| Nama_KA | varchar(20) | | | | |
| kelas | varchar(20) | | | | |
| no_kursi | varchar(20) | | | | |
| tgl_pesan | date | | | 0000-00-00 | |
| tgl_berangkat | date | | | 0000-00-00 | |
+---------------+-------------+------+-----+------------+-------+
11 rows in set (0.00 sec)
mysql> ALTER table penumpang
-> ADD FOREIGN KEY(id_penumpang)
-> REFERENCES frontoffice(id_penumpang);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER table petugas
-> ADD FOREIGN KEY(id_petugas)
-> REFERENCES frontoffice(id_petugas);
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER table kereta
-> ADD FOREIGN KEY(id_KA)
-> REFERENCES frontoffice(id_KA);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER table gerbong
-> ADD FOREIGN KEY(id_gerbong)
-> REFERENCES frontoffice(id_gerbong);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER table stasiun
-> ADD FOREIGN KEY(id_stasiun)
-> REFERENCES frontoffice(id_stasiun);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc tiketagent;
+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| nama_agent | varchar(20) | | PRI | | |
| kode_pembayaran | varchar(20) | | | | |
+-----------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> insert into tiketagent
-> values('Ayu','0009'),
-> ('Daniel','0008'),
-> ('Risma','00010'),
-> ('Atri','00011'),
-> ('Dina','00867'),
-> ('Nanda','0012'),
-> ('Dewa','00034'),
-> ('Rio','0034'),
-> ('Budi','0021'),
-> ('Lisa','9986');
Query OK, 10 rows affected (0.00 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from tiketagent;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Ayu | 0009 |
| Daniel | 0008 |
| Risma | 00010 |
| Atri | 00011 |
| Dina | 00867 |
| Nanda | 0012 |
| Dewa | 00034 |
| Rio | 0034 |
| Budi | 0021 |
| Lisa | 9986 |
+------------+-----------------+
10 rows in set (0.00 sec)
mysql> select nama_agent, kode_pembayaran from tiketagent;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Ayu | 0009 |
| Daniel | 0008 |
| Risma | 00010 |
| Atri | 00011 |
| Dina | 00867 |
| Nanda | 0012 |
| Dewa | 00034 |
| Rio | 0034 |
| Budi | 0021 |
| Lisa | 9986 |
+------------+-----------------+
10 rows in set (0.00 sec)
mysql> select nama_agent,kode_pembayaran from tiketagent where nama_agent='Lisa'
;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Lisa | 9986 |
+------------+-----------------+
1 row in set (0.00 sec)
mysql> select nama_agent,kode_pembayaran from tiketagent order by nama_agent;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Atri | 00011 |
| Ayu | 0009 |
| Budi | 0021 |
| Daniel | 0008 |
| Dewa | 00034 |
| Dina | 00867 |
| Lisa | 9986 |
| Nanda | 0012 |
| Rio | 0034 |
| Risma | 00010 |
+------------+-----------------+
10 rows in set (0.00 sec)
mysql> select nama_agent,kode_pembayaran from tiketagent order by nama_agent des
c;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Risma | 00010 |
| Rio | 0034 |
| Nanda | 0012 |
| Lisa | 9986 |
| Dina | 00867 |
| Dewa | 00034 |
| Daniel | 0008 |
| Budi | 0021 |
| Ayu | 0009 |
| Atri | 00011 |
+------------+-----------------+
10 rows in set (0.00 sec)
mysql> select nama_agent,kode_pembayaran from tiketagent order by nama_agent lim
it 0,3;
+------------+-----------------+
| nama_agent | kode_pembayaran |
+------------+-----------------+
| Atri | 00011 |
| Ayu | 0009 |
| Budi | 0021 |
+------------+-----------------+
3 rows in set (0.00 sec)
mysql> select count(*) from tiketagent;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc penumpang;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_penumpang | varchar(20) | | PRI | | |
| nama_penumpang | varchar(20) | | | | |
| alamat | varchar(20) | | | | |
| no_tlpn | varchar(20) | | | | |
+----------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> insert into penumpang
-> values('001','ayu','jln.berdikary','00909090008'),
-> ('002','Daniel','jln.sigunggung','0008989977789'),
-> ('003','Risma','jln.merdeka','0990945686946'),
-> ('098','Atri','Jln.Cendrawasi','012458742455'),
-> ('099','Dina','jln.kampus','081365987541'),
-> ('453','Nanda','jln.kulim','08124578975'),
-> ('555','Dewa','jln.imam','085824675555'),
-> ('898','Rio','jln.berdikari','012458678787'),
-> ('685','Budi','jln.soekarno','54654378543'),
-> ('569','Lisa','jln.Palas','564876345865');
Query OK, 10 rows affected (0.00 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from penumpang;
+--------------+----------------+----------------+---------------+
| id_penumpang | nama_penumpang | alamat | no_tlpn |
+--------------+----------------+----------------+---------------+
| 001 | ayu | jln.berdikary | 00909090008 |
| 002 | Daniel | jln.sigunggung | 0008989977789 |
| 003 | Risma | jln.merdeka | 0990945686946 |
| 098 | Atri | Jln.Cendrawasi | 012458742455 |
| 099 | Dina | jln.kampus | 081365987541 |
| 453 | Nanda | jln.kulim | 08124578975 |
| 555 | Dewa | jln.imam | 085824675555 |
| 898 | Rio | jln.berdikari | 012458678787 |
| 685 | Budi | jln.soekarno | 54654378543 |
| 569 | Lisa | jln.Palas | 564876345865 |
+--------------+----------------+----------------+---------------+
10 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang from penumpang;
+--------------+----------------+
| id_penumpang | nama_penumpang |
+--------------+----------------+
| 001 | ayu |
| 002 | Daniel |
| 003 | Risma |
| 098 | Atri |
| 099 | Dina |
| 453 | Nanda |
| 555 | Dewa |
| 898 | Rio |
| 685 | Budi |
| 569 | Lisa |
+--------------+----------------+
10 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang,alamat from penumpang where id_penumpa
ng='453';
+--------------+----------------+-----------+
| id_penumpang | nama_penumpang | alamat |
+--------------+----------------+-----------+
| 453 | Nanda | jln.kulim |
+--------------+----------------+-----------+
1 row in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang,no_tlpn from penumpang where no_tlpn
like '%08%';
+--------------+----------------+---------------+
| id_penumpang | nama_penumpang | no_tlpn |
+--------------+----------------+---------------+
| 001 | ayu | 00909090008 |
| 002 | Daniel | 0008989977789 |
| 099 | Dina | 081365987541 |
| 453 | Nanda | 08124578975 |
| 555 | Dewa | 085824675555 |
+--------------+----------------+---------------+
5 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang,alamat,no_tlpn from penumpang where al
amat='kulim'&& no_tlpn like '%08';
Empty set (0.00 sec)
mysql> select id_penumpang,nama_penumpang from penumpang order by nama_penumpang
;
+--------------+----------------+
| id_penumpang | nama_penumpang |
+--------------+----------------+
| 098 | Atri |
| 001 | ayu |
| 685 | Budi |
| 002 | Daniel |
| 555 | Dewa |
| 099 | Dina |
| 569 | Lisa |
| 453 | Nanda |
| 898 | Rio |
| 003 | Risma |
+--------------+----------------+
10 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang from penumpang order by nama_penumpang
desc;
+--------------+----------------+
| id_penumpang | nama_penumpang |
+--------------+----------------+
| 003 | Risma |
| 898 | Rio |
| 453 | Nanda |
| 569 | Lisa |
| 099 | Dina |
| 555 | Dewa |
| 002 | Daniel |
| 685 | Budi |
| 001 | ayu |
| 098 | Atri |
+--------------+----------------+
10 rows in set (0.00 sec)
mysql> select id_penumpang,nama_penumpang from penumpang order by nama_penumpang
limit 0,3;
+--------------+----------------+
| id_penumpang | nama_penumpang |
+--------------+----------------+
| 098 | Atri |
| 001 | ayu |
| 685 | Budi |
+--------------+----------------+
3 rows in set (0.00 sec)
mysql> select count(*) from penumpang;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc petugas;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_petugas | varchar(20) | | PRI | | |
| nama_petugas | varchar(20) | | | | |
| jabatan | varchar(20) | | | | |
| umur | varchar(20) | | | | |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> insert into petugas
-> values('01','risma','sekretaris','50'),
-> ('02','ayu','marketing','50'),
-> ('03','rika','bendahara','40'),
-> ('04','budi','parkir','55'),
-> ('05','bambang','supir','20'),
-> ('99','rita','manager','30'),
-> ('88','rio','kernet','60'),
-> ('76','dimas','direktur','22'),
-> ('22','andri ','OB','30'),
-> ('10','Gilang','OB1','50'),
mysql> select* from petugas;
+------------+--------------+------------+------+
| id_petugas | nama_petugas | jabatan | umur |
+------------+--------------+------------+------+
| 01 | risma | sekretaris | 50 |
| 02 | ayu | marketing | 50 |
| 03 | rika | bendahara | 40 |
| 04 | budi | parkir | 55 |
| 05 | bambang | supir | 20 |
| 99 | rita | manager | 30 |
| 88 | rio | kernet | 60 |
| 76 | dimas | direktur | 22 |
| 22 | andri | OB | 30 |
| 10 | Gilang | OB1 | 50 |
+------------+--------------+------------+------+
10 rows in set (0.00 sec)
mysql> select id_petugas,nama_petugas from petugas;
+------------+--------------+
| id_petugas | nama_petugas |
+------------+--------------+
| 01 | risma |
| 02 | ayu |
| 03 | rika |
| 04 | budi |
| 05 | bambang |
| 99 | rita |
| 88 | rio |
| 76 | dimas |
| 22 | andri |
| 10 | Gilang |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_petugas,nama_petugas,jabatan from petugas where id_petugas='99'
;
+------------+--------------+---------+
| id_petugas | nama_petugas | jabatan |
+------------+--------------+---------+
| 99 | rita | manager |
+------------+--------------+---------+
1 row in set (0.00 sec)
mysql> select id_petugas,nama_petugas,umur from petugas where umur like '%50%';
+------------+--------------+------+
| id_petugas | nama_petugas | umur |
+------------+--------------+------+
| 01 | risma | 50 |
| 02 | ayu | 50 |
| 10 | Gilang | 50 |
+------------+--------------+------+
3 rows in set (0.00 sec)
mysql> select id_petugas,nama_petugas,jabatan,umur from petugas where jabatan='s
upir'&&umur like '%20';
+------------+--------------+---------+------+
| id_petugas | nama_petugas | jabatan | umur |
+------------+--------------+---------+------+
| 05 | bambang | supir | 20 |
+------------+--------------+---------+------+
1 row in set (0.00 sec)
mysql> select id_petugas, nama_petugas from petugas order by nama_petugas;
+------------+--------------+
| id_petugas | nama_petugas |
+------------+--------------+
| 22 | andri |
| 02 | ayu |
| 05 | bambang |
| 04 | budi |
| 76 | dimas |
| 10 | Gilang |
| 03 | rika |
| 88 | rio |
| 01 | risma |
| 99 | rita |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_petugas, nama_petugas from petugas order by nama_petugas desc;
+------------+--------------+
| id_petugas | nama_petugas |
+------------+--------------+
| 99 | rita |
| 01 | risma |
| 88 | rio |
| 03 | rika |
| 10 | Gilang |
| 76 | dimas |
| 04 | budi |
| 05 | bambang |
| 02 | ayu |
| 22 | andri |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_petugas,nama_petugas from petugas order by nama_petugas limit 0
,3;
+------------+--------------+
| id_petugas | nama_petugas |
+------------+--------------+
| 22 | andri |
| 02 | ayu |
| 05 | bambang |
+------------+--------------+
3 rows in set (0.00 sec)
mysql> select count(*) from petugas;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc kereta;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_KA | varchar(30) | NO | PRI | | |
| Nama_KA | varchar(20) | NO | | | |
| Kelas | varchar(20) | NO | | | |
| tujuan | varchar(20) | NO | | | |
| Harga | varchar(20) | NO | | | |
| jam_tiba | varchar(20) | NO | | | |
| Jam_berangkat | varchar(20) | NO | | | |
| asal | varchar(20) | NO | | | |
| Jumlah_gerbong | varchar(20) | NO | | | |
+----------------+-------------+------+-----+---------+-------+
9 rows in set (0.10 sec)
mysql> insert into kereta
-> values('201','Logawa','Eksekutif','Purwokerto','50.000','15.00','10.00','Jember','10'),
-> ('202','Kertajaya','Bisnis','Surabaya','55.000','14.00','10.00','Tanjungpriok','11'),
-> ('203','Brantas','Ekonomi','Kediri','40.000','14.20','10.20','Pasarsenen','12'),
-> ('204','Kahuripan','Ekonomi AC','Tegal','50.000','14.50','10.40','Banyuwangi','13'),
-> ('205','Kahuripan','Ekonomi','Kutoarjo','55.000','15.10','10.55','Jakarta','14'),
-> ('206','Bengawan','Bisnis','Purwosari','65.000','15.20','11.00','Malang','15'),
-> ('207','Progo','Eksekutif','Lempuyangan','40.000','15.30','11.20','Tegal','16'),
-> ('208','Pasundan','Eksekutif','Malang','45.000','15.40','11.40','Jember','17'),
-> ('209','Sri Tanjung','Bisnis','Jakarta','60.000','15.50','11.45','Semarang','18'),
-> ('2010','Matarmaja','Ekonomi AC','Jogyakarta','55.000','16.00','11.50','Malang','19');
Query OK, 10 rows affected (0.64 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from kereta;
+-------+-------------+------------+-------------+--------+----------+----------
-----+--------------+----------------+
| id_KA | Nama_KA | Kelas | tujuan | Harga | jam_tiba | Jam_beran
gkat | asal | Jumlah_gerbong |
+-------+-------------+------------+-------------+--------+----------+----------
-----+--------------+----------------+
| 201 | Logawa | Eksekutif | Purwokerto | 50.000 | 15.00 | 10.00
| Jember | 10 |
| 202 | Kertajaya | Bisnis | Surabaya | 55.000 | 14.00 | 10.00
| Tanjungpriok | 11 |
| 203 | Brantas | Ekonomi | Kediri | 40.000 | 14.20 | 10.20
| Pasarsenen | 12 |
| 204 | Kahuripan | Ekonomi AC | Tegal | 50.000 | 14.50 | 10.40
| Banyuwangi | 13 |
| 205 | Kahuripan | Ekonomi | Kutoarjo | 55.000 | 15.10 | 10.55
| Jakarta | 14 |
| 206 | Bengawan | Bisnis | Purwosari | 65.000 | 15.20 | 11.00
| Malang | 15 |
| 207 | Progo | Eksekutif | Lempuyangan | 40.000 | 15.30 | 11.20
| Tegal | 16 |
| 208 | Pasundan | Eksekutif | Malang | 45.000 | 15.40 | 11.40
| Jember | 17 |
| 209 | Sri Tanjung | Bisnis | Jakarta | 60.000 | 15.50 | 11.45
| Semarang | 18 |
| 2010 | Matarmaja | Ekonomi AC | Jogyakarta | 55.000 | 16.00 | 11.50
mysql> select id_KA,Nama_KA,tujuan from kereta;
+-------+-------------+-------------+
| id_KA | Nama_KA | tujuan |
+-------+-------------+-------------+
| 201 | Logawa | Purwokerto |
| 202 | Kertajaya | Surabaya |
| 203 | Brantas | Kediri |
| 204 | Kahuripan | Tegal |
| 205 | Kahuripan | Kutoarjo |
| 206 | Bengawan | Purwosari |
| 207 | Progo | Lempuyangan |
| 208 | Pasundan | Malang |
| 209 | Sri Tanjung | Jakarta |
| 2010 | Matarmaja | Jogyakarta |
+-------+-------------+-------------+
10 rows in set (0.00 sec)
mysql> select id_KA,Nama_KA,Kelas from kereta where id_KA='206';
+-------+----------+--------+
| id_KA | Nama_KA | Kelas |
+-------+----------+--------+
| 206 | Bengawan | Bisnis |
+-------+----------+--------+
1 row in set (0.00 sec)
mysql> select id_KA,Nama_KA,Harga from kereta where Harga like '%50.000%';
+-------+-----------+--------+
| id_KA | Nama_KA | Harga |
+-------+-----------+--------+
| 201 | Logawa | 50.000 |
| 204 | Kahuripan | 50.000 |
+-------+-----------+--------+
2 rows in set (0.00 sec)
mysql> select id_KA,Nama_KA,tujuan,Harga from kereta where tujuan='Tegal'&&Harga
like '%50.000';
+-------+-----------+--------+--------+
| id_KA | Nama_KA | tujuan | Harga |
+-------+-----------+--------+--------+
| 204 | Kahuripan | Tegal | 50.000 |
+-------+-----------+--------+--------+
1 row in set (0.00 sec)
mysql> select id_KA,Nama_KA from kereta order by Nama_KA;
+-------+-------------+
| id_KA | Nama_KA |
+-------+-------------+
| 206 | Bengawan |
| 203 | Brantas |
| 204 | Kahuripan |
| 205 | Kahuripan |
| 202 | Kertajaya |
| 201 | Logawa |
| 2010 | Matarmaja |
| 208 | Pasundan |
| 207 | Progo |
| 209 | Sri Tanjung |
+-------+-------------+
10 rows in set (0.00 sec)
mysql> select id_KA,Nama_KA from kereta order by Nama_KA desc;
+-------+-------------+
| id_KA | Nama_KA |
+-------+-------------+
| 209 | Sri Tanjung |
| 207 | Progo |
| 208 | Pasundan |
| 2010 | Matarmaja |
| 201 | Logawa |
| 202 | Kertajaya |
| 205 | Kahuripan |
| 204 | Kahuripan |
| 203 | Brantas |
| 206 | Bengawan |
+-------+-------------+
10 rows in set (0.00 sec)
mysql> select id_KA,Nama_KA from kereta order by Nama_KA limit 0,3;
+-------+-----------+
| id_KA | Nama_KA |
+-------+-----------+
| 206 | Bengawan |
| 203 | Brantas |
| 204 | Kahuripan |
+-------+-----------+
3 rows in set (0.00 sec)
mysql> select count(*) from kereta;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc stasiun;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_stasiun | varchar(20) | NO | PRI | | |
| Nama_stasiun | varchar(20) | NO | | | |
| kelas | varchar(20) | NO | | | |
+--------------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)
mysql> select* from stasiun;
+------------+--------------+------------+
| id_stasiun | Nama_stasiun | kelas |
+------------+--------------+------------+
| 121 | Gresik | Bisnis |
| 120 | Depok | Ekonomi |
| 119 | Cibitung | Eksekutif |
| 118 | Bekasi | Bisnis |
| 117 | Baturaja | Eksekutif |
| 112 | Ancol | Eksekutif |
| 113 | Angke | Ekonomi AC |
| 114 | Bogor | Ekonomi |
| 115 | Banjar | Eksekutif |
| 116 | Bandung | Ekonomi AC |
+------------+--------------+------------+
10 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun from stasiun;
+------------+--------------+
| id_stasiun | Nama_stasiun |
+------------+--------------+
| 121 | Gresik |
| 120 | Depok |
| 119 | Cibitung |
| 118 | Bekasi |
| 117 | Baturaja |
| 112 | Ancol |
| 113 | Angke |
| 114 | Bogor |
| 115 | Banjar |
| 116 | Bandung |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun,kelas from stasiun where id_stasiun='112';
+------------+--------------+-----------+
| id_stasiun | Nama_stasiun | kelas |
+------------+--------------+-----------+
| 112 | Ancol | Eksekutif |
+------------+--------------+-----------+
1 row in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun,kelas from stasiun where kelas like '%Ekon
omi%';
+------------+--------------+------------+
| id_stasiun | Nama_stasiun | kelas |
+------------+--------------+------------+
| 113 | Angke | Ekonomi AC |
| 114 | Bogor | Ekonomi |
| 116 | Bandung | Ekonomi AC |
+------------+--------------+------------+
3 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun,kelas from stasiun where Nama_stasiun='Bog
or'&& kelas like '%Ekonomi';
+------------+--------------+---------+
| id_stasiun | Nama_stasiun | kelas |
+------------+--------------+---------+
| 114 | Bogor | Ekonomi |
+------------+--------------+---------+
1 row in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun from stasiun order by Nama_stasiun;
+------------+--------------+
| id_stasiun | Nama_stasiun |
+------------+--------------+
| 121 | Gresik |
| 120 | Depok |
| 119 | Cibitung |
| 118 | Bekasi |
| 117 | Baturaja |
| 112 | Ancol |
| 113 | Angke |
| 114 | Bogor |
| 115 | Banjar |
| 116 | Bandung |
+------------+--------------+
10 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun from stasiun order by Nama_stasiun desc;
+------------+--------------+
| id_stasiun | Nama_stasiun |
+------------+--------------+
| 121 | Gresik |
| 120 | Depok |
| 119 | Cibitung |
| 115 | Banjar |
| 116 | Bandung |
| 114 | Bogor |
| 118 | Bekasi |
| 117 | Baturaja |
| 113 | Angke |
| 112 | Ancol |
+------------+--------------+
15 rows in set (0.00 sec)
mysql> select id_stasiun,Nama_stasiun from stasiun order by Nama_stasiun limit 0
,3;
+------------+--------------+
| id_stasiun | Nama_stasiun |
+------------+--------------+
| 112 | Ancol |
| 113 | Angke |
| 11 | Bali |
+------------+--------------+
3 rows in set (0.00 sec)
mysql> select count(*) from stasiun;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc gerbong;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_gerbong | varchar(20) | NO | PRI | | |
| id_KA | varchar(20) | NO | | | |
| kelas | varchar(20) | NO | | | |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.04 sec)
mysql> insert into gerbong
-> values('303','201','Eksekutif'),
-> ('304','202','Ekonomi'),
-> ('305','203','Bisnis'),
-> ('306','204','Ekonomi'),
-> ('307','205','Eksekutif'),
-> ('308','206','Ekonomi AC'),
-> ('309','207','Ekonomi AC'),
-> ('3010','208','Ekonomi'),
-> ('3011','209','Bisnis'),
-> ('3012','2010','Eksekutif');
Query OK, 10 rows affected (0.06 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from gerbong;
+------------+-------+------------+
| id_gerbong | id_KA | kelas |
+------------+-------+------------+
| 303 | 201 | Eksekutif |
| 304 | 202 | Ekonomi |
| 305 | 203 | Bisnis |
| 306 | 204 | Ekonomi |
| 307 | 205 | Eksekutif |
| 308 | 206 | Ekonomi AC |
| 309 | 207 | Ekonomi AC |
| 3010 | 208 | Ekonomi |
| 3011 | 209 | Bisnis |
| 3012 | 2010 | Eksekutif |
+------------+-------+------------+
10 rows in set (0.00 sec)
mysql> select id_gerbong,id_KA from gerbong;
+------------+-------+
| id_gerbong | id_KA |
+------------+-------+
| 303 | 201 |
| 304 | 202 |
| 305 | 203 |
| 306 | 204 |
| 307 | 205 |
| 308 | 206 |
| 309 | 207 |
| 3010 | 208 |
| 3011 | 209 |
| 3012 | 2010 |
+------------+-------+
10 rows in set (0.00 sec)
mysql> select id_gerbong,id_KA,kelas from gerbong where id_gerbong='304';
+------------+-------+---------+
| id_gerbong | id_KA | kelas |
+------------+-------+---------+
| 304 | 202 | Ekonomi |
+------------+-------+---------+
1 row in set (0.00 sec)
mysql> select id_gerbong,id_KA kelas from gerbong where kelas like '%Ekonomi%';
+------------+-------+
| id_gerbong | kelas |
+------------+-------+
| 304 | 202 |
| 306 | 204 |
| 308 | 206 |
| 309 | 207 |
| 3010 | 208 |
+------------+-------+
5 rows in set (0.03 sec)
mysql> select id_gerbong,id_KA,kelas from gerbong where id_KA='202'&& kelas like
'%Ekonomi';
+------------+-------+---------+
| id_gerbong | id_KA | kelas |
+------------+-------+---------+
| 304 | 202 | Ekonomi |
+------------+-------+---------+
1 row in set (0.00 sec)
mysql> select id_gerbong,id_KA,kelas from gerbong order by id_KA;
+------------+-------+------------+
| id_gerbong | id_KA | kelas |
+------------+-------+------------+
| 303 | 201 | Eksekutif |
| 3012 | 2010 | Eksekutif |
| 304 | 202 | Ekonomi |
| 305 | 203 | Bisnis |
| 306 | 204 | Ekonomi |
| 307 | 205 | Eksekutif |
| 308 | 206 | Ekonomi AC |
| 309 | 207 | Ekonomi AC |
| 3010 | 208 | Ekonomi |
| 3011 | 209 | Bisnis |
+------------+-------+------------+
10 rows in set (0.00 sec)
mysql> select id_gerbong,id_KA from gerbong order by id_KA desc;
+------------+-------+
| id_gerbong | id_KA |
+------------+-------+
| 3011 | 209 |
| 3010 | 208 |
| 309 | 207 |
| 308 | 206 |
| 307 | 205 |
| 306 | 204 |
| 305 | 203 |
| 304 | 202 |
| 3012 | 2010 |
| 303 | 201 |
+------------+-------+
10 rows in set (0.00 sec)
mysql> select id_gerbong,id_KA from gerbong order by id_KA limit 0,3;
+------------+-------+
| id_gerbong | id_KA |
+------------+-------+
| 303 | 201 |
| 3012 | 2010 |
| 304 | 202 |
+------------+-------+
3 rows in set (0.00 sec)
mysql> select count(*) from gerbong;
+----------+
| count(*) |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> desc tiket;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| no_reservasi | varchar(20) | NO | PRI | | |
| id_penumpang | varchar(20) | NO | | | |
| id_petugas | varchar(20) | NO | | | |
| id_KA | varchar(20) | NO | | | |
| id_gerbong | varchar(20) | NO | | | |
| id_stasiun | varchar(20) | NO | | | |
| Nama_KA | varchar(20) | NO | | | |
| kelas | varchar(20) | NO | | | |
| no_kursi | varchar(20) | NO | | | |
| tgl_pesan | date | NO | | | |
| tgl_berangkat | date | NO | | | |
+---------------+-------------+------+-----+---------+-------+
11 rows in set (0.11 sec)
mysql> insert into tiket
-> values('40','020','001','201','303','112','Logawa','Eksekutif','1','2016-
04-10','2016-04-20'),
-> ('45','021','002','202','304','113','Kertajaya','Bisnis','2','2016-04-11'
,'2016-04-21'),
-> ('50','022','003','203','305','114','Brantas','Ekonomi','3','2016-04-12',
'2016-04-22'),
-> ('55','023','004','204','306','115','Kahuripan','Ekonomi AC','4','2016-04
-13','2016-04-23'),
-> ('60','024','005','205','307','116','Kahuripan','Ekonomi','5','2016-04-14
','2016-04-24'),
-> ('70','025','006','206','308','117','Bengawan','Bisnis','6','2016-04-15',
'2016-04-25'),
-> ('75','026','007','207','309','118','Progo','Eksekutif','7','2016-04-16',
'2016-04-26'),
-> ('80','027','008','208','3010','119','Pasundan','Eksekutif','8','2016-04-
17','2016-04-26'),
-> ('85','028','009','209','3011','120','Sri Tanjung','Bisnis','9','2016-04-
18','2016-04-23'),
-> ('90','029','010','2010','3012','121','Matarmaja','Ekonomi AC','10','2016
-04-19','2016-04-22');
Query OK, 10 rows affected (0.00 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select* from tiket;
+--------------+--------------+------------+-------+------------+------------+--
-----------+------------+----------+------------+---------------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun | N
ama_KA | kelas | no_kursi | tgl_pesan | tgl_berangkat |
+--------------+--------------+------------+-------+------------+------------+--
-----------+------------+----------+------------+---------------+
| 0102 | 020 | 001 | 201 | 303 | 112 | L
ogawa | Eksekutif | 1 | 2016-04-10 | 2016-04-20 |
| 01022 | 020 | 001 | 201 | 303 | 112 | L
ogawa | Eksekutif | 1 | 2016-04-10 | 2016-04-20 |
| 01033 | 021 | 002 | 202 | 304 | 113 | K
ertajaya | Bisnis | 2 | 2016-04-11 | 2016-04-21 |
| 40 | 020 | 001 | 201 | 303 | 112 | L
ogawa | Eksekutif | 1 | 2016-04-10 | 2016-04-20 |
| 45 | 021 | 002 | 202 | 304 | 113 | K
ertajaya | Bisnis | 2 | 2016-04-11 | 2016-04-21 |
| 50 | 022 | 003 | 203 | 305 | 114 | B
rantas | Ekonomi | 3 | 2016-04-12 | 2016-04-22 |
| 55 | 023 | 004 | 204 | 306 | 115 | K
ahuripan | Ekonomi AC | 4 | 2016-04-13 | 2016-04-23 |
| 60 | 024 | 005 | 205 | 307 | 116 | K
ahuripan | Ekonomi | 5 | 2016-04-14 | 2016-04-24 |
| 70 | 025 | 006 | 206 | 308 | 117 | B
engawan | Bisnis | 6 | 2016-04-15 | 2016-04-25 |
| 75 | 026 | 007 | 207 | 309 | 118 | P
rogo | Eksekutif | 7 | 2016-04-16 | 2016-04-26 |
| 80 | 027 | 008 | 208 | 3010 | 119 | P
asundan | Eksekutif | 8 | 2016-04-17 | 2016-04-26 |
| 85 | 028 | 009 | 209 | 3011 | 120 | S
ri Tanjung | Bisnis | 9 | 2016-04-18 | 2016-04-23 |
| 90 | 029 | 010 | 2010 | 3012 | 121 | M
atarmaja | Ekonomi AC | 10 | 2016-04-19 | 2016-04-22 |
+--------------+--------------+------------+-------+------------+------------+--
-----------+------------+----------+------------+---------------+
10 rows in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun f
rom tiket;
+--------------+--------------+------------+-------+------------+------------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun |
+--------------+--------------+------------+-------+------------+------------+
| 40 | 020 | 001 | 201 | 303 | 112 |
| 45 | 021 | 002 | 202 | 304 | 113 |
| 50 | 022 | 003 | 203 | 305 | 114 |
| 55 | 023 | 004 | 204 | 306 | 115 |
| 60 | 024 | 005 | 205 | 307 | 116 |
| 70 | 025 | 006 | 206 | 308 | 117 |
| 75 | 026 | 007 | 207 | 309 | 118 |
| 80 | 027 | 008 | 208 | 3010 | 119 |
| 85 | 028 | 009 | 209 | 3011 | 120 |
| 90 | 029 | 010 | 2010 | 3012 | 121 |
+--------------+--------------+------------+-------+------------+------------+
10 rows in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun,N
ama_KA from tiket where no_reservasi='70';
+--------------+--------------+------------+-------+------------+------------+--
--------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun | N
ama_KA |
+--------------+--------------+------------+-------+------------+------------+--
--------+
| 70 | 025 | 006 | 206 | 308 | 117 | B
engawan |
+--------------+--------------+------------+-------+------------+------------+--
--------+
1 row in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun,n
o_kursi from tiket where no_kursi like '%6%';
+--------------+--------------+------------+-------+------------+------------+--
--------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun | n
o_kursi |
+--------------+--------------+------------+-------+------------+------------+--
--------+
| 70 | 025 | 006 | 206 | 308 | 117 | 6
|
+--------------+--------------+------------+-------+------------+------------+--
--------+
1 row in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun,N
ama_KA,no_kursi from tiket where Nama_KA='Kahuripan'&& no_kursi like '%5';
+--------------+--------------+------------+-------+------------+------------+--
---------+----------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun | N
ama_KA | no_kursi |
+--------------+--------------+------------+-------+------------+------------+--
---------+----------+
| 60 | 024 | 005 | 205 | 307 | 116 | K
ahuripan | 5 |
+--------------+--------------+------------+-------+------------+------------+--
---------+----------+
1 row in set (0.00 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun f
rom tiket order by id_stasiun;
+--------------+--------------+------------+-------+------------+------------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun |
+--------------+--------------+------------+-------+------------+------------+
| 40 | 020 | 001 | 201 | 303 | 112 |
| 45 | 021 | 002 | 202 | 304 | 113 |
| 50 | 022 | 003 | 203 | 305 | 114 |
| 55 | 023 | 004 | 204 | 306 | 115 |
| 60 | 024 | 005 | 205 | 307 | 116 |
| 70 | 025 | 006 | 206 | 308 | 117 |
| 75 | 026 | 007 | 207 | 309 | 118 |
| 80 | 027 | 008 | 208 | 3010 | 119 |
| 85 | 028 | 009 | 209 | 3011 | 120 |
| 90 | 029 | 010 | 2010 | 3012 | 121 |
+--------------+--------------+------------+-------+------------+------------+
10 rows in set (0.01 sec)
mysql> select no_reservasi,id_penumpang,id_petugas,id_KA,id_gerbong,id_stasiun
from tiket order by id_stasiun desc;
+--------------+--------------+------------+-------+------------+------------+
| no_reservasi | id_penumpang | id_petugas | id_KA | id_gerbong | id_stasiun |
+--------------+--------------+------------+-------+------------+------------+
| 90 | 029 | 010 | 2010 | 3012 | 121 |
| 85 | 028 | 009 | 209 | 3011 | 120 |
| 80 | 027 | 008 | 208 | 3010 | 119 |
| 75 | 026 | 007 | 207 | 309 | 118 |
| 70 | 025 | 006 | 206 | 308 | 117 |
| 60 | 024 | 005 | 205 | 307 | 116 |
| 55 | 023 | 004 | 204 | 306 | 115 |
| 50 | 022 | 003 | 203 | 305 | 114 |
| 45 | 021 | 002 | 202 | 304 | 113 |
| 40 | 020 | 001 | 201 | 303 | 112 |
+--------------+--------------+------------+-------+------------+------------+
10 rows in set (0.00 sec)
mysql> select count(*) from tiket;
+----------+
| count(*) |
+----------+
| 13 |
+----------+
1 row in set (0.00 sec)
Komentar
Posting Komentar