试题图片:
数据库代码:create database dept DEFAULT charset=utf8;
use dept;
create table tbl_dept(
dept_id int primary key AUTO_INCREMENT,
dept_name varchar(30),
dept_office varchar(10)
);
insert into tbl_dept values(1,'市场部','1705');
insert into tbl_dept values(2,'财务部','1704');
insert into tbl_dept values(3,'采购部','1801');
insert into tbl_dept values(4,'技术支持部','1205');
select * from tbl_dept;
create table tbl_emp(
emp_id int primary key AUTO_INCREMENT,
emp_name varchar(20),
dept_id varchar(20),
emp_gender varchar(3)