存储过程与存储函数

#存储过程与存储函数
 #创建存储过程
 CREATE DATABASE dbtest15;
 USE dbtest15;
 
 CREATE TABLE employees
 AS
 SELECT *	
 FROM atguigudb.`employees`;
 
 CREATE TABLE departments
 AS
 SELECT *
 FROM atguigudb.`departments`;
 
 SELECT * FROM employees;
 
 SELECT * FROM departments;
 #1、创建存储过程select_all_data(),查看emps表中的所有数据
 DELIMITER $
 
 CREATE PROCEDURE select_all_data()
 BEGIN 
     SELECT * FROM employees;
 END $
 
 DELIMITER ;
 
 #存储过程的调用
 CALL select_all_data();