SQL语句笔记

查找重复记录，不记得哪儿找到的了

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;