MYSQL 存储过程创设

MYSQL 存储过程创建

mysql> delimiter //

?

1. >?create?procedure?p3(IN?nameid?int,?OUT?person_name?varchar(10)) ?->?begin ?
2. >?select?*?from?test.zzm; ?->?select?zzm.name?into?person_name?from?test.zzm?where?zzm.id?=?nameid; ?
3. >?end ?->?//
4. Query?OK,?0?rows?affected?(0.00?sec) ?