MySQL mask fields before creating dump RRS feed

  • Question

  • Hi I know this is for MSSQL forum but I just wanna ask if someone can answer my question.

    I have this database and I should create a dump file. But before that, I need to mask some fields for security purposes. I was able to mask the field with this:

    SELECT CONCAT(TRIM(REVERSE(SUBSTR(REVERSE(Account_Number),50,99))),' XXX') Account_Number

    FROM Client;

    Now I need to create the dump, having these values... 

    Any helpful information will be appreciated.. Thanks.

    Tuesday, June 14, 2011 9:56 AM


All replies