LATIHAN PRAKTIKUM

ysql> use haldamir;
Database changed
mysql> create table map(Code varchar(50), Region varchar(50), King varchar(50));

Query OK, 0 rows affected (0.01 sec)

mysql> desc map;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| Code   | varchar(50) | YES  |     | NULL    |       |
| Region | varchar(50) | YES  |     | NULL    |       |
| King   | varchar(50) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql> alter table map add Capital varchar(50) after Region;
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc map;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| Code    | varchar(50) | YES  |     | NULL    |       |
| Region  | varchar(50) | YES  |     | NULL    |       |
| Capital | varchar(50) | YES  |     | NULL    |       |
| King    | varchar(50) | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> alter table map rename to Middle;
Query OK, 0 rows affected (0.01 sec)

mysql> desc middle;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| Code    | varchar(50) | YES  |     | NULL    |       |
| Region  | varchar(50) | YES  |     | NULL    |       |
| Capital | varchar(50) | YES  |     | NULL    |       |
| King    | varchar(50) | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> alter table middle modify code varchar(10);
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc middle;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| code    | varchar(10) | YES  |     | NULL    |       |
| Region  | varchar(50) | YES  |     | NULL    |       |
| Capital | varchar(50) | YES  |     | NULL    |       |
| King    | varchar(50) | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> alter table middle change code Code_Reg varchar(10);
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc middle;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| Code_Reg | varchar(10) | YES  |     | NULL    |       |
| Region   | varchar(50) | YES  |     | NULL    |       |
| Capital  | varchar(50) | YES  |     | NULL    |       |
| King     | varchar(50) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> alter table middle drop king;
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc middle;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| Code_Reg | varchar(10) | YES  |     | NULL    |       |
| Region   | varchar(50) | YES  |     | NULL    |       |
| Capital  | varchar(50) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql> alter table middle add primary key (code_reg);
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc middle;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| Code_Reg | varchar(10) | NO   | PRI |         |       |
| Region   | varchar(50) | YES  |     | NULL    |       |
| Capital  | varchar(50) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql> insert into middle values('AR626','Arnor','Annuminas'),('HT657','Huthlum'
,'Barad Eithel');
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from middle;
+----------+---------+--------------+
| Code_Reg | Region  | Capital      |
+----------+---------+--------------+
| AR626    | Arnor   | Annuminas    |
| HT657    | Huthlum | Barad Eithel |
+----------+---------+--------------+
2 rows in set (0.00 sec)

mysql> truncate table middle;
Query OK, 2 rows affected (0.01 sec)

mysql> select*from middle;
Empty set (0.00 sec)