mysql 存储过程 删除重复
浏览数：22 /
时间：2015年06月12日
DELIMITER $$
CREATE PROCEDURE `delRepeatCA`()
BEGIN
DECLARE tally INT DEFAULT 0;
SELECT COUNT(rs.c_CA) INTO tally FROM --------赋值
(SELECT COUNT(c_CA) AS c_CA FROM t_CA
GROUP BY c_CA HAVING COUNT(1) > 1) rs
WHILE tally>0 DO --------循环
IF(tally>0)THEN
------------删除重复
DELETE t_CAAS a FROM t_CAAS a, (
SELECT MIN(c_id)AS c_id FROM t_CA GROUP BY c_CA HAVING COUNT(1) > 1)AS b
WHERE a.c_id = b.c_id;
SELECT COUNT(rs.c_CA) INTO tally FROM
(SELECT COUNT(c_CA) AS c_CA FROM t_CA
GROUP BY c_CA HAVING COUNT(1) > 1) rs
END IF;
END WHILE;
END$$
DELIMITER ;
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
