Knowledge Walls
John Peter
Pune, Maharashtra, India
DES_ENCRYPT() and DES_DECRYPT() Method in Mysql with Example
5127 Views
DES_ENCRYPT 
DES_ENCRYPT method is used to encrypt the given string with key using DES Algorithm.

Syntax
DES_ENCRYPT(data, key);

Example
SELECT DES_ENCRYPT("God is Great","yahooo");
DES_DECRYPT 
DES_DECRYPT method is used to decrypt the given encrypted data of DES_ENCRYPT method with key using DES Algorithm.

Syntax
DES_DECRYPT(aes_encrypted data, key);

Example
SELECT DES_DECRYPT(DES_ENCRYPT("God is Great","yahooo"),"yahooo");
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details