# 数据库1
create database db01;
use db01;

create table dept(
                     deptno bigint primary key not null auto_increment,
                     dname varchar(60),
                     db_source varchar(60)
);
alter table dept comment ='部门表';

insert into dept (dname, db_source)  value ('开发部',database());
insert into dept (dname, db_source)  value ('人事部',database());
insert into dept (dname, db_source)  value ('财务部',database());
insert into dept (dname, db_source)  value ('市场部',database());
insert into dept (dname, db_source)  value ('运维部',database());

select * from db01.dept;

# 数据库2
create database db02;
use db02;

create table dept(
                     deptno bigint primary key not null auto_increment,
                     dname varchar(60),
                     db_source varchar(60)
)ENGINE =INNODB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT ='部门表';

insert into dept (dname, db_source)  value ('开发部',database());
insert into dept (dname, db_source)  value ('人事部',database());
insert into dept (dname, db_source)  value ('财务部',database());
insert into dept (dname, db_source)  value ('市场部',database());
insert into dept (dname, db_source)  value ('运维部',database());

select * from db02.dept;

# 数据库3
create database db03;
use db03;

create table dept(
                     deptno bigint primary key not null auto_increment,
                     dname varchar(60),
                     db_source varchar(60)
)ENGINE =INNODB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT ='部门表';

insert into dept (dname, db_source)  value ('开发部',database());
insert into dept (dname, db_source)  value ('人事部',database());
insert into dept (dname, db_source)  value ('财务部',database());
insert into dept (dname, db_source)  value ('市场部',database());
insert into dept (dname, db_source)  value ('运维部',database());

select * from db03.dept;