mysql数据库防篡改

-- 使用预编译语句示例
PREPARE stmt FROM 'SELECT * FROM users WHERE username = ? AND password = ?';
EXECUTE stmt USING @username, @password;
DEALLOCATE PREPARE stmt;

-- 使用校验和示例
DELIMITER //
CREATE TRIGGER check_data_integrity
BEFORE UPDATE ON users
FOR EACH ROW
BEGIN
    SET NEW.checksum = SHA2(NEW.data, 256);
END //
DELIMITER ;

-- 创建审计表
CREATE TABLE audit_log (
    id INT AUTO_INCREMENT PRIMARY KEY,
    table_name VARCHAR(256),
    operation VARCHAR(256),
    old_data TEXT,
    new_data TEXT,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 创建触发器示例
DELIMITER //
CREATE TRIGGER audit_trigger
AFTER UPDATE ON users
FOR EACH ROW
BEGIN
    INSERT INTO audit_log (table_name, operation, old_data, new_data)
    VALUES ('users', 'UPDATE', OLD.data, NEW.data);
END //
DELIMITER ;