AES ENCRYPT/DECRYPT 처리

SYNTAX

 - AES_ENCRYPT($str, $key)

$str : string which will be encrypted

$key : string for encrypt ( Must be 16byte )

  사용법

mysql> SELECT AES_ENCRYPT("TEST", "1234567890123456") FROM DUAL

- DES_ENCRYPT($encryptedStr, $key)

$str : string which is encrypted

$key : string for encrypt ( Must be 16byte )

  사용법

mysql> SELECT AES_DECRYPT("ENCRYPTED_STR", "1234567890123456") FROM DUAL