dcsimg
 

Submitted by: M S Sridhar(sridhar.ms@gmail.com)

Friday Aug 2nd 2019 by M S Sridhar

Learn how to understand the AES ENCRYPTION method that is supported by MySQL.

Learn how to understand the AES ENCRYPTION method that is supported by MySQL.

Syntax:

SELECT AES_ENCRYPT('myPassWord','PASSWORD');

Here, the TEXT 'myPassWord' is the text that has to be encrypted and the KEY to encrypt is 'PASSWORD'

Sample output:

+---------------------------------------+
| AES_ENCRYPT('myPassWord','PASSWORD')  |
+---------------------------------------+
| (?|??n>?_??                |
+---------------------------------------+

Note: The output is only an illustration and depends on various attributes such as 128-bit, 256-bit, etc.

Home
Mobile Site | Full Site