写一个存储过程,以后就可以一性删除。 如: mysql > CREATE PROCEDURE demo_in_parameter(IN p_in int) -> BEGIN -> delete from 表名1 where 字段=p_in; -> delete from 表名2 where 字段=p_in; -> delete from 表名3 where 字段=p_in; -> END; 以后删除就调用存储过程 mysql > SET @p_in=1; mysql > CALL demo_in_parameter(@p_in);