输入为NULL时输出也是NULL
mysql> SELECT PASSWORD('w3resource'); +-------------------------------------------+ | PASSWORD('w3resource') | +-------------------------------------------+ | *EE0804DDC2CC3E85A47191ECCCBA29B775DFFA77 | +-------------------------------------------+ 1 row in set (0.00 sec) Referencehttps://www.w3resource.com/mysql/encryption-and-compression-functions/decode().php
https://blog.csdn.net/Gpwner/article/details/51598344?depth_1-utm_source=distribute.pc_relevant.none-task&utm_source=distribute.pc_relevant.none-task