打开游标取值 OR 如果唯一, SELECT uid INTO @UID FROM users WHERE qqOpenid=qqOpenid_v;
您好,就是在这句话查询的时候,一并赋值给变量。最好不查询,不然又查询一次了DECLARE uid_v TINYINT; SELECT uid_v ,guidKey,userName,qqImg,experience,rankType,introduction INTO id_v FROM users WHERE qqOpenid=qqOpenid_v;
SELECT uid_v ,guidKey,userName,qqImg,experience,rankType,introduction INTO id_v FROM users WHERE qqOpenid=qqOpenid_v;这个语句不就已经把 introduction 字段赋值给 id_v 了吗?
SELECT uid_v ,guidKey,userName,qqImg,experience,rankType,introduction INTO id_v FROM users WHERE qqOpenid=qqOpenid_v; 变量不够
OR
如果唯一,
SELECT uid INTO @UID FROM users WHERE qqOpenid=qqOpenid_v;
您好,就是在这句话查询的时候,一并赋值给变量。最好不查询,不然又查询一次了DECLARE uid_v TINYINT;
SELECT uid_v ,guidKey,userName,qqImg,experience,rankType,introduction INTO id_v FROM users WHERE qqOpenid=qqOpenid_v;
变量不够