一、修改结束符
delimiter //
二、创建带in模式的存储过程
create procedure myp3(in name varchar(20))
begin
select last_name,salary,employee_id
from employees
where last_name=name;
end //
三、调用
call myp3('Nayer')//
四、查询结果
+-----------+---------+-------------+
| last_name | salary | employee_id |
+-----------+---------+-------------+
| Nayer | 3200.00 | 125 |
+-----------+---------+-------------+