mysql存儲過程中局部變量定義在代碼最前面，作用范圍也是在此函數范圍內。注意同全局變量和用戶變量區分開。

使用declare關鍵字來聲明變量

注意必須寫在代碼塊的最前面

de count int DEFAULT 0;
DECLARE username varchar(32);

一次聲明多個相同類型的變量

	DECLARE p_parent int DEFAULT 0;
	DECLARE parent0, parent1, parent2, parent3, parent4, parent5 int DEFAULT 0;

使用set來給變量賦值

set <變量名> = <值>

				 DECLARE sflag int default 0;
				 set sflag =100;

select 語句給變量賦值

select 列名 into 變量名，支持多個變量同時賦值。

SELECT col_name[, …] INTO var_name[,…] from table

SELECT IFNULL(cnt,0) into parent0 from temp_student where b = 0 limit 1;

select sname, sno into p_name, p_no from temp_student where id=888;
select 'result:', p_no, p_name;

游標賦值

DECLARE p_id int;
DECLARE p_name varchar(32);
DECLARE sflag int DEFAULT 0;
DECLARE cur_school CURSOR FOR select id,name from school where status=0;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET sflag = 1;

open cur_school;		
		fetch cur_school into p_id, p_name;  
		while sflag<>1 do      
       // ......
      fetch cur_school into p_id, p_name;  
      select 'in while:',p_id, sflag;
		end while;
close cur_school;