Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Encrypts the given ciphertext using the AES (Advanced Encryption Standard) algorithm, with a 128-bit key.
AES_ENCRYPT(ciphertext, key)
The “ciphertext” of encrypted data, in binary.
Note: the HEX function is used in this example to make it easier to handle binary data.
SELECT HEX(AES_ENCRYPT('secret message', 'ohai'));
+--------------------------------------------+
| HEX(AES_ENCRYPT('secret message', 'ohai')) |
+--------------------------------------------+
| C958FF3BC0134ADE4A8F952338C1FAEC |
+--------------------------------------------+
Related Topics