### データ挿入
insert into department (department_code, department_name) values (‘a’, ‘営業部’);
insert into department (department_code, department_name) values (‘b’, ‘総務部’);
insert into department values (‘c’, ‘製造部’);
insert into department (department_code, department_name) values (‘d’, ‘経理部’);
insert into department (department_code, department_name) values (‘e’, ‘人事部’);
insert into department (department_code, department_name) values (‘f’, ‘物流部’);
### データ取得
select * from department;
select department_code, department_name from department;
select department_code as “部署コード”, department_name as “部署名” from department;
select department_code, department_name from department where department_code = ‘b’;
### データ更新
update department set department_name = ‘hoge’ where department_code = ‘a’;
### データ削除
delete from department;
delete from department where department_code = ‘c’;
delete from department where department_code in(‘a’, ‘c’, ‘e’);
