Mysql 基本命令

1. 备份某个DB

   mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql

   
   
2. 导入数据库

   mysql -h localhost -uroot -proot db<c:/db.sql

   
   
3. 查询重复

   select user_name,count(*) as count from user_table group by user_name having count>1; 

   
   
4. 删除重复数据

   DELETE FROM `article` USING `article`,( SELECT DISTINCT MIN(`id`) AS `id`,`link` FROM `article` GROUP BY `link`  HAVING COUNT(link) > 1) AS `t2` WHERE `article`.`link` = `article`.`link` AND `article`.`id` <> `t2`.`id`