MYSQL 存储过程创设

MYSQL 存储过程创建

mysql> delimiter //

?

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