最新回答 / 小疯尐
1、第一句楼主写得明显有问题,SELECT查询两个字段都是t1表的,后面附加语句完全没意义,与其类似的一句是“DELETE t1 FROM tdb_goods AS t1 LEFT JOIN (SELECT 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.goo...
2016-01-01