mysql加密一列数据库

DELIMITER //

CREATE FUNCTION AES_ENCRYPT(data TEXT, key TEXT)
RETURNS TEXT
DETERMINISTIC
BEGIN
    DECLARE encrypted TEXT;
    SET encrypted = AES_ENCRYPT(data, key);
    RETURN encrypted;
END //

DELIMITER ;

DELIMITER //

CREATE FUNCTION AES_DECRYPT(data TEXT, key TEXT)
RETURNS TEXT
DETERMINISTIC
BEGIN
    DECLARE decrypted TEXT;
    SET decrypted = AES_DECRYPT(data, key);
    RETURN decrypted;
END //

DELIMITER ;

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

INSERT INTO users (id, name, credit_card) VALUES (1, 'Alice', AES_ENCRYPT('1234-5678-9012-3456', 'mysecretkey'));

SELECT id, name, AES_DECRYPT(credit_card, 'mysecretkey') AS credit_card FROM users;