Mysql> Select the encode (" MySQL ", "YIYI"), decode, encode (" MySQL ", "YIYI"), "YIYI");
ERROR ERROR 1305 (42000) : the FUNCTION market. The encode does not exist
I mysql 5.8, how to do?

CodePudding user response:

New version of ENCRYPT (), ENCODE () and DECODE (), DES_ENCRYPT (), and DES_DECRYPT () have been cancelled, MYSQL official suggested that use AES_ENCRYPT () and AES_DECRYPT () to replace,

CodePudding user response:

What version your mysql?

This is the document
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html