create database dbtest15
use dbtest15
create table employees
as
select *
from atguigudb.employees
create table employees
as
select *
from atguigudb.departments

创建存储过程

举例1：创建存储过程select_all_data()，查看emps表的所有数据

DELIMITER $
CREATE PROCEDURE select_all_data()
BEGIN
    SELECT * FROM employees;
END $
DELIMITER;

存储过程的调用

CALL select_all_data();

举例2：创建存储过程avg_employee_salary()，返回所有员工的平均工资

DELIMITER //
CREATE PROCEDURE avg_employee_salary()
BEGIN
    SELECT AVG(salary) FROM employees;
END //
DELIMITER ;