MySQL-库和表的管理-案例讲解

案例1

#创建表
use books

create table dept1(
   id int(7),
   name varchar(25)
);

select * from `dept1`

2.将表departments中的数据插入新表dept2中

#2.将表departments中的数据插入新表dept2中
use `books`;

create table dept2
select `department_id`,`department_name`
from `myemployees`.`departments`;

案例3

案例4-6

案例7-9