56,687
社区成员
发帖
与我相关
我的任务
分享
SELECT `charge` INTO `ID` FROM `tbl_name` WHERE conditions;
delimiter ||
create procedure test()
begin
declare charge int;
select charge:=ID from test1 where ID=1; 或者 select ID from test1 where ID=1 into charge;
if charge = 1 then
select 'Error';
end if;
end||
delimiter ;