All geek questions in one place

Mysql data masking

Hi I would like to take a production database and use it in a private development environment. But I would like to anonymize the data.

I searched for an hour, but all I find is for Oracle or SQL Server ... nothing for mysql.

I have approximately 15 tables with 75 fields that need to be anonymized.

Has anyone found a recommended solution (s)?

+3
source share
2 answers

You can anonymize all records in a MySQL table simply with

UPDATE users SET email = concat('user_', id, '@example.com');

. SQL Update . 1 user_1@example.com, 10 user_10@example.com ..

+6

Gartner, Camouflage mysql .

- http://www.datamasking.com/products/featured-product-downloads

Cheers, Adrienne

Fluid International Inc. www.fluidinternational.com

0

Source: https://habr.com/ru/post/1793407/

More articles:


All Articles