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内内容为随机字符
最新推荐文章于 2022-10-27 18:29:09 发布
UPDATE
users
SET
email = md5(random()::text || random()::text) || '@gogogo.com'
WHERE
users.id > 100000 and users.id < 1000000 and email NOT LIKE '%*%';