/*
SQLyog Ultimate v10.00 Beta1
MySQL - 5.7.29 : Database - yggl
*/
/!40101 SET NAMES utf8 /;
/!40101 SET SQL_MODE=''/;
/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
CREATE DATABASE /!32312 IF NOT EXISTS/yggl /!40100 DEFAULT CHARACTER SET utf8 /;
USE yggl;
/Table structure for table departments /
DROP TABLE IF EXISTS departments;
CREATE TABLE departments (department_number char(3) NOT NULL,department_name char(20) NOT NULL,remark varchar(100) DEFAULT NULL,
PRIMARY KEY (department_number)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/Data for the table departments /
/Table structure for table employees /
DROP TABLE IF EXISTS employees;
CREATE TABLE employees (employeeid char(6) NOT NULL,name char(10) NOT NULL,education char(4) NOT NULL,birth date NOT NULL,sex char(2) NOT NULL,workyear int(1) DEFAULT NULL,address varchar(20) DEFAULT NULL,phonenumber char(12) DEFAULT NULL,departmentid char(3) DEFAULT NULL,
PRIMARY KEY (employeeid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/Data for the table employees /
insert into employees(employeeid,name,education,birth,sex,workyear,address,phonenumber,departmentid) values ('1','张一','本科','1998-01-28','男',1,'山东省','10001','1');
/Table structure for table salary /
DROP TABLE IF EXISTS salary;
CREATE TABLE salary (employeeid char(6) NOT NULL,income float(8,2) NOT NULL,expend float(8,2) NOT NULL,
PRIMARY KEY (employeeid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/Data for the table salary /
/ Procedure structure for procedure proc_name /
/!50003 DROP PROCEDURE IF EXISTS proc_name /;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE proc_name()
begin
select * from departments;
select * from employees;
end */$$
DELIMITER ;
/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;
