高手进来看看 这个代码什么意思?
DELIMITER $$ //这个是什么? 我没有看懂。
DROP PROCEDURE IF EXISTS `test`.`sp_zerofill`$$
CREATE PROCEDURE `test`.`sp_zerofill`(IN num int)
BEGIN
declare i int default 1;
-- initialization value
set @sqltext = 'insert into lk14 values(0,''char0'')';
-- begin while
while i < num do
set @sqltext = concat(@sqltext,',','(',i,',''char',ceil(num*rand()),''')');
set i = i + 1;
end while;
-- begin dynamic sql
prepare s1 from @sqltext;
execute s1;
deallocate prepare s1;
END$$
DELIMITER ;