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

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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