dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Aug 2, 2019

Understand the AES Encryption Method

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.

M S Sridhar
 
Thanks for your registration, follow us on our social networks to keep up-to-date