mysql批量插入数据uuid去重 

1 update base_problem set uuid=replace(uuid(),'-','');
2 update base_problem set uuid = UUID() where uuid =uuid;
3 update base_problem set uuid = REPLACE(uuid,'-','');

 

posted @ 2019-12-09 14:40  AnxSky  阅读(1485)  评论(1)  编辑  收藏  举报