存储过程1-用户登录实现

BEGINset @u_id=0; // 定义变量存储用户IDset @u_name=''; //定义变量存储用户名set @_result='success_login'; // 保存结果select id,user_name into @u_id, @u_name from user_sys where user_name=_user_name AND user_pwd=_user_pwd;IF @u_id=1 THENset @_result='error_login';end if;// 把结果合并返回select * from (select @_result) a,(select @u_id, @u_name) b;END