mysql数据库的数据无法删除 |linux mysql odbc配置

一、受外键限制

ALTER TABLE `table1` DROP FOREIGN KEY `fk_name`;
DELETE FROM `table1` WHERE `condition`;
DELETE FROM `table2` WHERE `condition`;

二、表被锁定

SHOW PROCESSLIST;
KILL `Id`;

三、权限不足

GRANT DELETE ON `database`.`table` TO `user`@`%`;
FLUSH PRIVILEGES;

需要注意的是，删除数据时一定要谨慎，要先备份数据，以防误操作导致数据丢失。