很是疑问,来看看共同进步
删除语句 的语法 DELETE FROM TABLE WHERE 条件
那下面那个语句DELETE t1 FROM 用别名啥意思 ??语法没错???求详解
DELETE t1 FROM tdb_goods AS t1 LEFT JOIN (SELECT ANY_VALUE(goods_id),goods_name FROM tdb_goods GROUP BY goods_name HAVING count(goods_name) >= 2 ) AS t2 ON t1.goods_name = t2.goods_name WHERE t1.goods_id > t2.goods_id;
