mysql 表数据改成密文

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    credit_card VARBINARY(255)
);

DELIMITER //

CREATE FUNCTION encrypt_credit_card(credit_card VARCHAR(255), key VARCHAR(255))
RETURNS VARBINARY(255)
DETERMINISTIC
BEGIN
    DECLARE encrypted_card VARBINARY(255);
    SET encrypted_card = AES_ENCRYPT(credit_card, key);
    RETURN encrypted_card;
END //

DELIMITER ;

INSERT INTO users (id, name, credit_card)
VALUES (1, 'John Doe', encrypt_credit_card('1234-5678-9012-3456', 'my_secret_key'));

DELIMITER //

CREATE FUNCTION decrypt_credit_card(encrypted_card VARBINARY(255), key VARCHAR(255))
RETURNS VARCHAR(255)
DETERMINISTIC
BEGIN
    DECLARE credit_card VARCHAR(255);
    SET credit_card = AES_DECRYPT(encrypted_card, key);
    RETURN credit_card;
END //

DELIMITER ;

SELECT id, name, decrypt_credit_card(credit_card, 'my_secret_key') AS credit_card
FROM users;