Best of 'ForgetSQL'

gistfile1.txt

#MYSQL DB DUMP FROM REMOTE SERVER
mysqldump -h host_ip -u username -p --databases xxx_db > xxx.sql

#MYSQL DB DUMP RESTORE TO REMOTE SERVER
mysql -h host_ip -u username -p xxx_db < xxx.sql

#MySQL TIMESTAMP TO DATE Update
UPDATE table SET col_to=DATE_FORMAT(FROM_UNIXTIME(col_from),"%Y-%m-%d %H:%i:%s");

#MYSQL UPDATE "ME"
UPDATE table SET x = 1 WHERE id IN (SELECT MIN(id) FROM (SELECT * FROM table) AS table_alias GROUP BY y)

#MYSQL DELETE DUPLICATES BY MULTIPLE VALUES AND KEEP THE LATEST ONE
 delete keyLocale
   from keyLocale
  inner join (
     select max(kl_id) as lastId, kl_project_id, kl_locale_id, kl_key_id, kl_value
       from keyLocale
      group by kl_project_id, kl_locale_id, kl_key_id 
     having count(*) > 1) duplic on (duplic.kl_project_id = keyLocale.kl_project_id AND duplic.kl_locale_id = keyLocale.kl_locale_id AND duplic.kl_key_id = keyLocale.kl_key_id)
  where keyLocale.kl_id < duplic.lastId;