课程
/数据库
/MySQL
/与MySQL的零距离接触
- - 有哪位朋友可以分享一波数据的sql吗。。
2018-05-01
源自：与MySQL的零距离接触 5-1
正在回答
DELETE t1 FROM rdb_goods AS t1 LEFT OUTER JOIN
(SELECT goods_id,goods_name FROM tdb_goods GROUP BY goods_name HAVINNG COUNT(goods_name)>1 ORDER BY goods_id) AS t2
ON t1.goods_name=t2.goods_name
WHERE t1.goods_id>t2.goods_id;
举报
本课程涵盖全部MySQL数据库的基础，学习MySQL数据库的基础知识
