How to encrypt table records for only some columns?
Can encrypt some columns with encryption UDF as following.
A. create function LIBCRYPT.AES_ENCRYPT(string,string) returns string;
create function LIBCRYPT.AES_DECRYPT(string,string) returns string;
B. insert into tableXX(columnXX) values(AES_ENCRYPT(‘XXXXXX’, 'user_defined_key'));
Or update tableXX set columnXX=AES_ENCRYPT(columnXX, 'user_defined_key');
C. select AES_DECRYPT(column1, ‘user_defined_key’) from table1;
Version: 5.4.x
Product: Normal/Bundle
Platform: Windows/Linux