Mysql 存储过程查询结果赋值到变量的方法

使用into的方法(单个赋值)

select id into @id from tbl_currentWeather where cityid = _cityid;

 多个赋值

select  @id:=id,@cityid:=cityid  from tbl_currentWeather where cityid = _cityid;