=删除重复数据,先追加自增 id
ALTER TABLE `simi_lar` ADD `id` INT ( 1 ) NOT NULL AUTO_INCREMENT,
ADD INDEX `id` ( `id` );
=删除重复数据
DELETE
FROM
`simi_lar` USING `simi_lar`,
(
SELECT DISTINCT
MIN( `id` ) AS `id`,
`article_id`,
`ar_id`
FROM
`simi_lar`
GROUP BY
`article_id`,
`ar_id`
HAVING
COUNT( 1 ) > 1
) AS `t2`
WHERE
`simi_lar`.`article_id` = `t2`.`article_id`
AND `simi_lar`.`ar_id` = `t2`.`ar_id`
AND `simi_lar`.`id` <> `t2`.`id`;
= 删除id字段 =
ALTER TABLE `simi_lar` DROP `id`;