MYSQL 存储过程创设
MYSQL 存储过程创建
mysql> delimiter //
- mysql> create procedure p3(IN nameid int, OUT person_name varchar(10))
- -> begin
- -> select * from test.zzm;
- -> select zzm.name into person_name from test.zzm where zzm.id = nameid;
- -> end
- -> //
- Query OK, 0 rows affected (0.00 sec)