求MYSQL删除语句

[qqsweb]

SELECT *
FROM `SELECT *
FROM `ecs_goods_fanli`
WHERE `cat_id` =2
LIMIT 0 , 30

删除ecs_goods_fanli表 cat_id字段所有等于2的数据

[yafei_ren]

delete from ecs_goods_fanli where cat_id=2,你还要查询出来吗？

[qqsweb]

[Quote=引用 1 楼 yafei_ren 的回复:]
delete from ecs_goods_fanli where cat_id=2,你还要查询出来吗？
[/Quote]

这条够用了 3Q