SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete elect @@session.block_encryption_mode; SET @@session.block_encryption_mode = 'aes-256-cbc'; select @@session.block_encryption_mode; SET @key_str = '키문자'; SET @init_vector = REPEAT(CHAR(0),16); SET @crypt_str = 'hPxO5YtjequGwvf2WOd9Kg=='; SET @encrypt_str = 'test'; SELECT TO_BASE64(AES_ENCRYPT(@encrypt_str,@key_str,@init_vector)) AS 'ENC'; SELECT AES_DECRYPT(from_base64(@crypt_str),@key_str,@init_vector) AS 'DEC'; SELECT cast(AES_DECRYPT(from_base64(@crypt_str),@key_str,@init_vector) as char) AS 'DEC';