抓猪问题,走光视频,赢辛
mysql存储过程
drop function if exists `fun_convert`$
create definer=`root`@`%` function `fun_convert`(para varchar(255))
returns varchar(255) charset gbk
begin
declare result varchar(255) default '';
declare cnt int default 0;
declare i int default 0;
declare id bigint default 0;
set cnt = length(para) - length(replace(para,',',''))-1;
while i < cnt do
select c.id into id from company c where c.code = substring(para,i*3+2,2);
set result = concat(result, ",",id);
set i = i+1;
end while;
set result = concat(result, ",");
return result;
end
$
delimiter ;
update users u set u.company = fun_convert(u.company);
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
小白安装登录mysql-8.0.19-winx64的教程图解(新手必看)
Navicat连接MySQL时报10060、1045错误及my.ini位置问题
网友评论