美文网首页
循坏更改auuid

循坏更改auuid

作者: 下班再说 | 来源:发表于2020-09-21 11:08 被阅读0次

    CREATE DEFINER=`root`@`localhost` PROCEDURE `auuid`()

    BEGIN

    DECLARE i INT ( 4 );

    set i=1;

    WHILE i <> 300 DO

    set i=i+1 ;

    UPDATE table_name set auuid = REPLACE(UUID(),'-','') where id=(SELECT min(id) from (select id from table_name WHERE auuid = "5") as A);

    END WHILE;

    END

    相关文章

      网友评论

          本文标题:循坏更改auuid

          本文链接:https://www.haomeiwen.com/subject/ibqvyktx.html