mysql数据库删不掉

-- 检查外键约束
SHOW CREATE TABLE your_table;

-- 删除外键约束
ALTER TABLE your_table DROP FOREIGN KEY your_foreign_key;

-- 禁用触发器
DELIMITER //
CREATE PROCEDURE disable_triggers()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE trigger_name VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT trigger_name FROM information_schema.triggers WHERE event_object_schema = 'your_database' AND event_object_table = 'your_table';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    OPEN cur;
    read_loop: LOOP
        FETCH cur INTO trigger_name;
        IF done THEN
            LEAVE read_loop;
        END IF;
        SET @sql = CONCAT('DROP TRIGGER ', trigger_name);
        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;
END //
DELIMITER ;
CALL disable_triggers();

-- 删除数据
DELETE FROM your_table WHERE your_condition;

-- 提交事务
START TRANSACTION;
DELETE FROM your_table WHERE your_condition;
COMMIT;