mysql存储过程，select 给变量赋值

SELECT
	fans_id INTO m
FROM
	t_weixin_fans
WHERE
	wx_open_id = i
LIMIT 1;

也可以对多个变量赋值：select a,b INTO m,n from tablename

limit 1是必须的。