mysql 存储过程删除重复数据

CREATE TABLE `blog_article` (
	`uid` VARCHAR(64) NOT NULL,
	`rangID` BIGINT(20) NOT NULL DEFAULT '0',
	`lon` VARCHAR(32) NOT NULL,
	`lat` VARCHAR(32) NOT NULL,
	`name` VARCHAR(64) NULL DEFAULT NULL
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;


 INSERT INTO blog_article VALUES ('123', '111', '100','11','zzz');
 INSERT INTO blog_article VALUES ('123', '112', '100','11','zzz');
 INSERT INTO blog_article VALUES ('121', '222', '200','21','qq');
 INSERT INTO blog_article VALUES ('121', '221', '200','21','qq');
 INSERT INTO blog_article VALUES ('120', '333', '300','33','qa');
 INSERT INTO blog_article VALUES ('120', '332', '300','33','qa');
 INSERT INTO blog_article VALUES ('119', '444', '44','400','mm');
 INSERT INTO blog_article VALUES ('119', '441', '44','400','mm');
 INSERT INTO blog_article VALUES ('118', '555', '55','500','nnn');
 INSERT INTO blog_article VALUES ('118', '554', '55','500','nnn');
 INSERT INTO blog_article VALUES ('117', '666', '66','600','kkk');
 INSERT INTO blog_article VALUES ('117', '606', '66','600','kkk');
 INSERT INTO blog_article VALUES ('116', '777', '77','700','ddd');
 INSERT INTO blog_article VALUES ('116', '787', '77','700','ddd');
 INSERT INTO blog_article VALUES ('115', '888', '800','800','ff');
 INSERT INTO blog_article VALUES ('115', '888', '800','88','ff');
 INSERT INTO blog_article VALUES ('114', '999', '900','88','pp');
 INSERT INTO blog_article VALUES ('114', '999', '900','99','pp');


DROP PROCEDURE IF EXISTS Proc_Cursor;
DELIMITER $$

CREATE PROCEDURE Proc_Cursor()
BEGIN
  DECLARE Done INT DEFAULT FALSE; -- 遍历数据结束标志定义
  DECLARE strUID VARCHAR(64);
  DECLARE rangIdInt bigint(20);
  DECLARE strlon VARCHAR(32);
  DECLARE strlat VARCHAR(32);
  DECLARE rs CURSOR FOR select uid, rangID,lon,lat FROM testDB.blog_article WHERE uid in (select uid from (select uid,count(1) as num from blog_article group by uid) T where T.num>1); -- 定义游标

  DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET Done = TRUE; -- 游标结束/异常处理

  OPEN rs; -- 结束游标
  FETCH NEXT FROM rs INTO strUID, rangIdInt,strlon,strlat; -- 遍历游标取值

  REPEAT
    IF NOT Done THEN
      -- FETCH NEXT FROM rs INTO strName, strAddress; -- 遍历游标取值放在此处则后面不需要再放
      START TRANSACTION; -- 开始事务
      
      if (convert(strlon, SIGNED) + convert(strlat, SIGNED)) != rangIdInt  then
      	INSERT INTO testDB.blog_article_copy(uid, rangID,lon,lat) VALUES( strUID, rangIdInt, strlon, strlat);
      	delete from testDB.blog_article where uid = strUID and rangID = rangIdInt;
      end if;

      COMMIT; -- 提交事务
    END IF;

  FETCH NEXT FROM rs INTO strUID, rangIdInt,strlon,strlat; -- 循环遍历处理
  UNTIL Done END REPEAT; -- 结束遍历
  CLOSE rs; -- 关闭游标
END$$
DELIMITER ;

call Proc_Cursor();

注意：定义变量名称时，变量名要与原表中的字段名称有区别，因为mysql不区分大小写；