How can I merge two MySQL tables?

by

You can also try:

INSERT IGNORE
  INTO table_1 
SELECT *
  FROM table_2
     ;

which allows those rows in table_1 to supersede those in table_2 that have a matching primary key, while still inserting rows with new primary keys.

Alternatively, 

REPLACE
   INTO table_1
 SELECT *
   FROM table_2
      ;

will update those rows already in table_1 with the corresponding row from table_2, while inserting rows with new primary keys.

More Related Contents:

  1. INNER JOIN ON vs WHERE clause
  2. MySQL: Alternatives to ORDER BY RAND()
  3. MySQL LIKE IN()?
  4. Auto Increment after delete in MySQL
  5. In MySQL queries, why use join instead of where?
  6. MySQL function to find the number of working days between two dates
  7. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  8. Alter a MySQL column to be AUTO_INCREMENT
  9. Importance of varchar length in MySQL table
  10. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  11. mySQL :: insert into table, data from another table?
  12. Return 0 if field is null in MySQL
  13. MySQL “between” clause not inclusive?
  14. MySQL syntax for Join Update
  15. SQL – How to transpose?
  16. MySQL remove duplicates from big database quick
  17. How to delete from select in MySQL?
  18. How to ORDER BY a SUM() in MySQL?
  19. mySQL Returning the top 5 of each category
  20. SQL SELECT to get the first N positive integers
  21. Sorting string column containing numbers in SQL?
  22. Multiple Ranks in one table
  23. The difference between ‘AND’ and ‘&&’ in SQL
  24. How can I make an average of dates in MySQL?
  25. What is the best way to generate ranks in MYSQL?
  26. What does collation mean?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment