DB
MariaDB AES Encrypt, Decrypt
code0xff
2021. 4. 24. 15:19
1. AES로 암호화할 컬럼은 BLOB으로 생성
create table encrypt_test_table (
encrypt_test_id bigint(20) not null auto_increment,
encrypted blob not null,
primary key (encrypt_test_id)
);
2. AES_ENCRYPT
insert into encrypt_test_table (encrypted) values (AES_ENCRYPT('message', SHA2('secret_key', 256)));
3. AES_DECRYPT
select AES_DECRYPT(encrypted, SHA2('secret_key', 256)) as decrypted from encrypt_test_table;