Unanswered: How to encrypt the result of a select statement?
I want to export the data from a database and place it on a csv file to be imported to another database. However, I want some columns from the selected data (result of select statement) to be encrypted. What should I do? Is this possible? How do you decrypt the data during import?
The original data is from an MS SQL database to be transferred to a PostgreSQL database.
Using the SELECT OUTFILE and the various encryption functions available in MySQL this is possible. This will output the contents in CSV format with the sensitive data encrypted. Then it is possible to perform operations during a LOAD INTO on the contents being loaded where we decrypt the same information.