建表
show databases;
create database multi_query;
use multi_query;
drop table if exists staff;
drop table if exists department;
create table department
(
de_id int primary key auto_increment,
de_name varchar(20)
);
create table staff
(
id int primary key auto_increment,
name varchar(20),
gender char(1),
salary double,
join_date date,
depart_id int,
foreign key (depart_id) references department (de_id)
);
insert into department (de_name)
values ('研发部')