mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| practice           |
| sys                |
| tokai              |
+--------------------+
6 rows in set (0.04 sec)

mysql> use tokai;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_tokai |
+-----------------+
| department      |
| employee        |
+-----------------+
2 rows in set (0.01 sec)

mysql> create table new_department like department;
Query OK, 0 rows affected (0.06 sec)

mysql> insert into new_department select*from department;
Query OK, 3 rows affected (0.01 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> show tables;
+-----------------+
| Tables_in_tokai |
+-----------------+
| department      |
| employee        |
| new_department  |
+-----------------+
3 rows in set (0.00 sec)

mysql> select*from new_department;
+--------+-----------------------+-------+
| dep_id | name                  | floor |
+--------+-----------------------+-------+
| D001   | 総務部                |     8 |
| D002   | 人材開発部            |     8 |
| D003   | システム開発部        |    12 |
+--------+-----------------------+-------+
3 rows in set (0.00 sec)

mysql> insert into new_department values ('D004','営業部',12);
Query OK, 1 row affected (0.01 sec)

mysql> select*from new_department;
+--------+-----------------------+-------+
| dep_id | name                  | floor |
+--------+-----------------------+-------+
| D001   | 総務部                |     8 |
| D002   | 人材開発部            |     8 |
| D003   | システム開発部        |    12 |
| D004   | 営業部                |    12 |
+--------+-----------------------+-------+
4 rows in set (0.00 sec)

mysql> insert into new_department (dep_id,name,floor) values ('D005','経理部',8);
Query OK, 1 row affected (0.01 sec)

mysql> select*from new_department;
+--------+-----------------------+-------+
| dep_id | name                  | floor |
+--------+-----------------------+-------+
| D001   | 総務部                |     8 |
| D002   | 人材開発部            |     8 |
| D003   | システム開発部        |    12 |
| D004   | 営業部                |    12 |
| D005   | 経理部                |     8 |
+--------+-----------------------+-------+
5 rows in set (0.00 sec)

mysql> create table new_employee like employee;
Query OK, 0 rows affected (0.04 sec)

mysql> insert into new_employee select*from employee;
Query OK, 7 rows affected (0.01 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql> update new_employee set name='山田太郎' where emp_id='E00001';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select*from new_employee where emp_id='E00001';
+--------+--------------+--------+------------+--------+--------+
| emp_id | name         | gender | birthday   | salary | dep_id |
+--------+--------------+--------+------------+--------+--------+
| E00001 | 山田太郎     | 男     | 1995-01-01 |   NULL | NULL   |
+--------+--------------+--------+------------+--------+--------+
1 row in set (0.00 sec)

mysql> update new_employee set salary=0.7*salary where gender='女';
Query OK, 3 rows affected (0.01 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> select name,gender,salary from new_employee;
+--------------+--------+--------+
| name         | gender | salary |
+--------------+--------+--------+
| 山田太郎     | 男     |   NULL |
| 佐藤次郎     | 男     | 250000 |
| 鈴木花子     | 女     | 175000 |
| 田中三郎     | 男     | 400000 |
| 高橋良子     | 女     | 210000 |
| 鈴木良枝     | 女     | 315000 |
| 佐藤健次     | 男     | 350000 |
+--------------+--------+--------+
7 rows in set (0.00 sec)