mysql 查询语句


DELETE
FROM
    dd_item
WHERE
    dd_item.id IN (

SELECT * from(

                SELECT
                    a.id
                FROM
                    dd_item a
                LEFT JOIN dd_item_cat b ON a.class_id = b.id
                WHERE
                    b.parent_id=23 and 

(b.name in ('生蚝','带鱼','黄鳝'))

            ) as ee
   )
//mysql 根据查询子条件进行删除表的记录