CREATE DEFINER=`root`@`localhost` PROCEDURE `j_select`(IN obj INT,IN type INT)
begin
declare code varchar(50) default 'zhusngq';
declare i int(1) default 0;
while i<5 do
set code = concat(code,i);
set i = i+1;
end while;
select code;
end;
mysql——存储过程示例
最新推荐文章于 2024-03-06 08:15:00 发布