How Can We Encrypt And Decrypt A Data Presented In A Table Using Mysq

1.	How Can We Encrypt And Decrypt A Data Presented In A Table Using Mysql?
Answer» You can USE FUNCTIONS: AES_ENCRYPT() and AES_DECRYPT() LIKE: AES_ENCRYPT(STR, key_str) AES_DECRYPT(crypt_str, key_str) You can use functions: AES_ENCRYPT() and AES_DECRYPT() like: AES_ENCRYPT(str, key_str) AES_DECRYPT(crypt_str, key_str)

How Can We Encrypt And Decrypt A Data Presented In A Table Using Mysql?

Answer»

You can USE FUNCTIONS: AES_ENCRYPT() and AES_DECRYPT() LIKE:

AES_ENCRYPT(STR, key_str)
AES_DECRYPT(crypt_str, key_str)

You can use functions: AES_ENCRYPT() and AES_DECRYPT() like:

AES_ENCRYPT(str, key_str)
AES_DECRYPT(crypt_str, key_str)