Guest User

Untitled

a guest
Nov 21st, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. # Move stats from new user to old user
  2. UPDATE
  3. tb_user OldUser,
  4. (
  5. SELECT
  6. level,
  7. points,
  8. minutes_in_chat_online,
  9. minutes_in_chat_offline
  10. FROM tb_user
  11. WHERE
  12. username='mikkael') NewUser
  13. SET
  14. OldUser.level=NewUser.level,
  15. OldUser.points+=NewUser.points,
  16. OldUser.minutes_in_chat_online+=NewUser.minutes_in_chat_online,
  17. OldUser.minutes_in_chat_offline+=NewUser.minutes_in_chat_offline
  18. WHERE
  19. OldUser.username='mike_1311'
  20. LIMIT 1;
  21.  
  22. # Remove new user
  23. DELETE FROM tb_user WHERE username='mikkael' LIMIT 1;
  24.  
  25. # Update username of old user
  26. UPDATE tb_user SET username='mikkael' WHERE username='mike_1311' LIMIT 1;
Add Comment
Please, Sign In to add comment