查找重复记录,不记得哪儿找到的了
SELECT * FROM user a WHERE ((SELECT COUNT(*) FROM user WHERE uname = a.uname) > 1) ORDER BY uname DESC
MySQL 建库指定编码
CREATE DATABASE IF NOT EXISTS db_name default charset utf8 COLLATE utf8_general_ci;
查找重复记录,不记得哪儿找到的了
SELECT * FROM user a WHERE ((SELECT COUNT(*) FROM user WHERE uname = a.uname) > 1) ORDER BY uname DESC
MySQL 建库指定编码
CREATE DATABASE IF NOT EXISTS db_name default charset utf8 COLLATE utf8_general_ci;