使用into的方法(单个赋值)
select id into @id from tbl_currentWeather where cityid = _cityid;
多个赋值
select @id:=id,@cityid:=cityid from tbl_currentWeather where cityid = _cityid;
使用into的方法(单个赋值)
select id into @id from tbl_currentWeather where cityid = _cityid;
多个赋值
select @id:=id,@cityid:=cityid from tbl_currentWeather where cityid = _cityid;