You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.


Encrypts the given ciphertext using the AES (Advanced Encryption Standard) algorithm, with a 128-bit key.


AES_ENCRYPT(ciphertext, key)


  • ciphertext: the binary data to encrypt
  • key: the text or binary key to use for encryption

Return Type

The “ciphertext” of encrypted data, in binary.


Note: the HEX function is used in this example to make it easier to handle binary data.

memsql> select hex(AES_ENCRYPT('secret message', 'ohai'));
| hex(AES_ENCRYPT('secret message', 'ohai')) |
| C958FF3BC0134ADE4A8F952338C1FAEC           |

Related Topics