mysql> create table new_department like department;
Query OK, 1 row affected (0.00 sec)

mysql> insert into new_employee
     >-serect * from employee;
Query OK, 1 row affected (0.03 sec)

mysql> show tables;
+--------------------+
| Tables_in_practice |
+--------------------+
| department         |
| employee           |
| new_department     |
| takanawa           |
+--------------------+
4 rows in set (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.03 sec)


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


mysql> select * from new_employee;
+--------+----------+--------+------------+--------+--------+
| emp_id | name     | gender | birthday   | salary | dep_id |
+--------+----------+--------+------------+--------+--------+
| E00001 | 山田太郎 | 男     | 1995-01-01 |   NULL | NULL   |
| E00002 | 佐藤次郎 | 男     | 1990-05-03 | 250000 | D001   |
| E00003 | 鈴木花子 | 女     | 1990-02-11 | 227500 | D002   |
| E00004 | 田中三郎 | 男     | 1975-11-03 | 400000 | D003   |
| E00005 | 高橋良子 | 女     | 1985-11-23 | 273000 | D003   |
| E00006 | 鈴木良枝 | 女     | 1970-05-03 | 409500 | D003   |
| E00007 | 佐藤健次 | 男     | 1980-05-05 | 350000 | D001   |
| E00008 | 山本景子 | 女     | 1996-12-25 | 250000 | D002   |
| E00009 | 渡辺五郎 | 男     | 1997-08-11 | 250000 | D004   |
+--------+----------+--------+------------+--------+--------+
9 rows in set (0.01 sec)


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

mysql> select * from new_employee;
+--------+----------+--------+------------+--------+--------+
| emp_id | name     | gender | birthday   | salary | dep_id |
+--------+----------+--------+------------+--------+--------+
| E00001 | 山田太郎 | 男     | 1995-01-01 |   NULL | NULL   |
| E00002 | 佐藤次郎 | 男     | 1990-05-03 | 250000 | D001   |
| E00003 | 鈴木花子 | 女     | 1990-02-11 | 227500 | D002   |
| E00004 | 田中三郎 | 男     | 1975-11-03 | 400000 | D003   |
| E00005 | 高橋良子 | 女     | 1985-11-23 | 273000 | D003   |
| E00006 | 鈴木良枝 | 女     | 1970-05-03 | 409500 | D003   |
| E00007 | 佐藤健次 | 男     | 1980-05-05 | 350000 | D001   |
| E00008 | 山本景子 | 女     | 1996-12-25 | 227500 | D002   |
| E00009 | 渡辺五郎 | 男     | 1997-08-11 | 250000 | D004   |
+--------+----------+--------+------------+--------+--------+
9 rows in set (0.00 sec)