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;

posted @ 2020-11-15 19:34  天机主神  阅读(63)  评论(0)    收藏  举报