Listing CMD.EXE-MYSQL.EXE

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\User>cd..

C:\Users>cd..

C:\>cd apache2triad\mysql\bin

C:\apache2triad\mysql\bin>mysql.exe
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases
    -> show databases;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'show
databases' at line 2
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
+--------------------+
2 rows in set (0.13 sec)

mysql> create database pesawat;
Query OK, 1 row affected (0.07 sec)

mysql> use databases pesawat;
ERROR 1049 (42000): Unknown database 'databases'
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| pesawat            |
+--------------------+
3 rows in set (0.00 sec)

mysql> use database pesawat;
ERROR 1049 (42000): Unknown database 'database'
mysql> use pesawat;
Database changed
mysql> show tables;
Empty set (0.03 sec)

mysql> create table karyawan(kd_kar char (3) primary key,nm_kar varchar(10),alam
at varchar (20),telephon varchar (15));
Query OK, 0 rows affected (0.06 sec)

mysql> insert into pesawat values("dis","dio septiansyah","cengkareng","1234564"
);
ERROR 1146 (42S02): Table 'pesawat.pesawat' doesn't exist
mysql> insert into karyawan values("dis","dio septiansyah","cengkareng","1234564
");
Query OK, 1 row affected, 1 warning (0.03 sec)

mysql> insert into karyawan values("sis","salsabila putri","bsd","789101112");
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into karyawan values("dwm","dwiantomi","pondok aren","112233445566
767");
Query OK, 1 row affected (0.00 sec)

mysql> describe karyawan;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| kd_kar   | char(3)     | NO   | PRI |         |       |
| nm_kar   | varchar(10) | YES  |     | NULL    |       |
| alamat   | varchar(20) | YES  |     | NULL    |       |
| telephon | varchar(15) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> select *from karyawan;
+--------+------------+-------------+-----------------+
| kd_kar | nm_kar     | alamat      | telephon        |
+--------+------------+-------------+-----------------+
| dis    | dio septia | cengkareng  | 1234564         |
| sis    | salsabila  | bsd         | 789101112       |
| dwm    | dwiantomi  | pondok aren | 112233445566767 |
+--------+------------+-------------+-----------------+
3 rows in set (0.01 sec)

mysql> create table pesawat (kd_pesawat char (7) primary key,nm_pesawat varchar(
10),tujuan varchar (20),harga int);
Query OK, 0 rows affected (0.01 sec)

mysql> describe pesawat;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| kd_pesawat | char(7)     | NO   | PRI |         |       |
| nm_pesawat | varchar(10) | YES  |     | NULL    |       |
| tujuan     | varchar(20) | YES  |     | NULL    |       |
| harga      | int(11)     | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> insert into pesawat values("grd","garuda indonesia","bali",800000);
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into pesawat values("lia","lion air","surabaya",600000);
Query OK, 1 row affected (0.00 sec)

mysql> insert into pesawat values("aia","air asia","batam",550000);
Query OK, 1 row affected (0.00 sec)

mysql> select *from pesawat;
+------------+------------+----------+--------+
| kd_pesawat | nm_pesawat | tujuan   | harga  |
+------------+------------+----------+--------+
| grd        | garuda ind | bali     | 800000 |
| lia        | lion air   | surabaya | 600000 |
| aia        | air asia   | batam    | 550000 |
+------------+------------+----------+--------+
3 rows in set (0.00 sec)

mysql> alter table karyawan add jnsklamin varchar (6);
Query OK, 3 rows affected (0.05 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select *from karyawan;
+--------+------------+-------------+-----------------+-----------+
| kd_kar | nm_kar     | alamat      | telephon        | jnsklamin |
+--------+------------+-------------+-----------------+-----------+
| dis    | dio septia | cengkareng  | 1234564         | NULL      |
| sis    | salsabila  | bsd         | 789101112       | NULL      |
| dwm    | dwiantomi  | pondok aren | 112233445566767 | NULL      |
+--------+------------+-------------+-----------------+-----------+
3 rows in set (0.00 sec)

mysql> alter table karyawan modify jnsklamin varchar(1);
Query OK, 3 rows affected (0.06 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> describe karyawan;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| kd_kar    | char(3)     | NO   | PRI |         |       |
| nm_kar    | varchar(10) | YES  |     | NULL    |       |
| alamat    | varchar(20) | YES  |     | NULL    |       |
| telephon  | varchar(15) | YES  |     | NULL    |       |
| jnsklamin | varchar(1)  | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
5 rows in set (0.06 sec)

mysql> alter table karyawan change jnsklamin jenis_klm varchar(1);
Query OK, 3 rows affected (0.02 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> describe karyawan;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| kd_kar    | char(3)     | NO   | PRI |         |       |
| nm_kar    | varchar(10) | YES  |     | NULL    |       |
| alamat    | varchar(20) | YES  |     | NULL    |       |
| telephon  | varchar(15) | YES  |     | NULL    |       |
| jenis_klm | varchar(1)  | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> alter table karyawan drop jenis_klm;
Query OK, 3 rows affected (0.05 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> describe karyawan;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| kd_kar   | char(3)     | NO   | PRI |         |       |
| nm_kar   | varchar(10) | YES  |     | NULL    |       |
| alamat   | varchar(20) | YES  |     | NULL    |       |
| telephon | varchar(15) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> update pesawat set tujuan="jogyakarta" where kd_pesawat="grd";
Query OK, 1 row affected (0.23 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select *from pesawat;
+------------+------------+------------+--------+
| kd_pesawat | nm_pesawat | tujuan     | harga  |
+------------+------------+------------+--------+
| grd        | garuda ind | jogyakarta | 800000 |
| lia        | lion air   | surabaya   | 600000 |
| aia        | air asia   | batam      | 550000 |
+------------+------------+------------+--------+
3 rows in set (0.00 sec)

mysql> select *from nm_kar;
ERROR 1146 (42S02): Table 'pesawat.nm_kar' doesn't exist
mysql> select nm_kar *karyawan;
ERROR 1054 (42S22): Unknown column 'nm_kar' in 'field list'
mysql> select nm_kar from karyawan;
+------------+
| nm_kar     |
+------------+
| dio septia |
| salsabila  |
| dwiantomi  |
+------------+
3 rows in set (0.01 sec)

mysql> select *from karyawan where kd_kar="sis";
+--------+------------+--------+-----------+
| kd_kar | nm_kar     | alamat | telephon  |
+--------+------------+--------+-----------+
| sis    | salsabila  | bsd    | 789101112 |
+--------+------------+--------+-----------+
1 row in set (0.01 sec)

mysql> select nm_pesawat from pesawat where tujuan="jogyakarta;
    "> select nm_pesawat from pesawat where tujuan="jogyakarta";
    "> select nm_pesawat from pesawat where tujuan="jogyakarta";
    "> select nm_pesawat from pesawat where tujuan = "jogyakarta";
    "> "
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'jogya
karta";
select nm_pesawat from pesawat where tujuan="jogyakarta";
select nm' at line 1
mysql> select nm_pesawat from pesawat where tujuan = "jogyakarta";
+------------+
| nm_pesawat |
+------------+
| garuda ind |
+------------+
1 row in set (0.00 sec)

mysql>