· 8 years ago · Aug 24, 2018, 04:46 AM
1CREATE TABLE IF NOT EXISTS `temp_dup_name` (
2 `guid` int(11) NOT NULL,
3 `name` varchar(100) NOT NULL,
4 `count` int(11) NOT NULL,
5 PRIMARY KEY (`guid`)
6) ENGINE=MyISAM DEFAULT CHARSET=utf8;
7INSERT INTO temp_dup_name SELECT max(guid), `name`, COUNT(*) AS `count` FROM `characters` GROUP BY `name` HAVING `count` > 1;
8UPDATE `characters` SET `at_login` = `at_login` | 1 WHERE `guid` IN (SELECT `guid` from `temp_dup_name`);
9DROP TABLE `temp_dup_name`;