在mysql存储过程或函数是否能实现select后如下功能
:
create procedure test1(in @name char,in @pwd char,out @type char,out @level char)
begin
定义一个变量 x = select * from admin where admin_name=@name and admin_pwd=@pwd; //x为符合条件的那一条记录
if(x)
{
@type=x.admin_type;
@level=x.admin_level;
}
end
小生是个初学者,刚刚开始学习数据库编程,请大家多多指导,在此多谢.
:
create procedure test1(in @name char,in @pwd char,out @type char,out @level char)
begin
定义一个变量 x = select * from admin where admin_name=@name and admin_pwd=@pwd; //x为符合条件的那一条记录
if(x)
{
@type=x.admin_type;
@level=x.admin_level;
}
end
小生是个初学者,刚刚开始学习数据库编程,请大家多多指导,在此多谢.
begindeclare @type int;
declare @level int;
set @type =0;
set @level =0;
select admin_type into @type, admin_level into @level from admin where admin_name=@name and admin_pwd=@pwd;
if(@type<>0 and @ level<>0)
{...}
end;