In MySQL, The AES_ENCRYPT ('Password', 'key') function can encrypt field values.

AES_ENCRYPT (

AES_ENCRYPT (

In MySQL, The AES_ENCRYPT ('Password', 'key') function can encrypt field values.

AES_DECRYPT (Table field name, 'key') function decryption

For example, table structure:

Insert a piece of data to encrypt the passwd password field.

Insert into credit_card (cid, NAME, email, passwd)

VALUES (101, 'hechunyang', 'hechunyang @ 163.com ', AES_ENCRYPT ('20140901', 'hechunyang '));

, Successfully inserted. Let's take a look at the effect of database encryption:

We can see that it is encrypted and garbled.

The user needs to perform verification when logging on, and the program needs to be decrypted, through the AES_DECRYPT function (the Field name of the table, 'key ')

SELECT cid, NAME, email, AES_DECRYPT (passwd, 'hechunyang') as passwd FROM credit_card

WHERE;

As you can see, it has been decrypted.