양방향 암호화 함수 생성
암호화 함수DELIMITER $$CREATE FUNCTION fn_encrypt(p_val VARCHAR(255)) RETURNS varchar(1000)beginDECLARE r_encrypt VARCHAR(1000); select HEX(AES_ENCRYPT(p_val, SHA2('abc123@!', 256))) into r_encrypt from dual; return r_encrypt;end select fn_encrypt('1234') from dual; 복구화 함수DELIMITER $$CREATE FUNCTION fn_decrypt(p_val VARCHAR(255)) RETURNS varchar(1000)beginDECLARE r_decrypt VARCHAR(1000); select CON..
DB/Mysql(maryaDB)
2024. 6. 3. 20:09
