mysql复制表.txt 850 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. REPLACE INTO ro21.role (
  2. uid,
  3. serverid,
  4. device_id,
  5. nick_name,
  6. base_level,
  7. create_date,
  8. last_login_date,
  9. map_level,
  10. max_fight_power,
  11. fight_power,
  12. active_code,
  13. open_id,
  14. sub_platform,
  15. tower_level,
  16. vip,
  17. money,
  18. zeny,
  19. total_recharge,
  20. ban_date,
  21. ban_chat_date,
  22. last_recharge_time)
  23. SELECT uid,
  24. serverid,
  25. device_id,
  26. nick_name,
  27. base_level,
  28. create_date,
  29. last_login_date,
  30. map_level,
  31. max_fight_power,
  32. fight_power,
  33. active_code,
  34. open_id,
  35. sub_platform,
  36. tower_level,
  37. vip,
  38. money,
  39. zeny,
  40. total_recharge,
  41. ban_date,
  42. ban_chat_date,
  43. last_recharge_time
  44. FROM ro22.role;