procedure make data
DELIMITER $$
drop procedure if exists tableInsert;
CREATE PROCEDURE tableInsert()
BEGIN
declare i INT;
declare uu_id VARCHAR(64);
SET i = 0;
while i<10 do
SET uu_id = REPLACE(UUID(),'-','');
if i >=9
then
###sql
else
###sql
END IF;
set i=i+1;
end while;
commit;
END $$
CALL tableInsert;

浙公网安备 33010602011771号