用法:
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;
用法:
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/liang545621/p/9959360.html