UPDATE
users
SET
email = md5(random()::text || random()::text) || '@gogogo.com'
WHERE
users.id > 100000 and users.id < 1000000 and email NOT LIKE '%*%';
UPDATE
users
SET
email = md5(random()::text || random()::text) || '@gogogo.com'
WHERE
users.id > 100000 and users.id < 1000000 and email NOT LIKE '%*%';
本文标题:Postgres 替换column内内容为随机字符
本文链接:https://www.haomeiwen.com/subject/byjsbctx.html
网友评论