## 删除重复中最小（大） ``` DELETE FROM student INNER JOIN ( SELECT min(table_id) AS minId, age FROM student GROUP BY name HAVING count(*) > 1 ) t2 ON t2.age = student.age WHERE student.table_id > t2.minId; ``` ## 表锁死后的操作 ``` mysql -uroot -pMySQL123 -e "show processlist;" | grep -i 'delete' | awk '{printf "mysql -uroot -e \"kill %d;\"",$1}' | sh ```