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)