MySQL ENCODE和DECODE加密列

用法:

ENCODE(str,passwd)
DECODE(str,passwd)

INSERT INTO test_log_1 VALUES (30,ENCODE("30","passwd"));

select id,DECODE(name_id,"passwd") from test_log_1 where id=30;

原文地址:https://www.cnblogs.com/l10n/p/9959360.html