删除重复记录
DELETE a
FROM
weibo_data AS a,
(
SELECT
WEIBODATA_ID,
WEIBO_ID
FROM
weibo_data
GROUP BY
WEIBODATA_ID
) AS b
WHERE
a.WEIBO_ID = b.WEIBO_ID
AND a.WEIBODATA_ID < b.WEIBODATA_ID
删除重复记录
DELETE a
FROM
weibo_data AS a,
(
SELECT
WEIBODATA_ID,
WEIBO_ID
FROM
weibo_data
GROUP BY
WEIBODATA_ID
) AS b
WHERE
a.WEIBO_ID = b.WEIBO_ID
AND a.WEIBODATA_ID < b.WEIBODATA_ID