How to merge the data from two tables in MySQL?

2 years ago
Liam
1 minute

In MySQL, you can merge data from two tables by using the UNION operator.

Assume there are two tables: table1 and table2, with the same column structure. To combine the data from these two tables, you can use the following syntax:

SELECT * FROM table1
UNION
SELECT * FROM table2;

This will return a result set that combines data from two tables. Please note that when using the UNION operator, the number of columns in the query must be the same and must be arranged in the same order.

If you want to include duplicate rows, you can use the UNION ALL operator. For example:

SELECT * FROM table1
UNION ALL
SELECT * FROM table2;

This will return all rows, including duplicate rows, after merging data from two tables.

In summary, the steps to merge data from two tables in MySQL are as follows:

  1. Ensure that both tables have the same column structure.
  2. Combine two SELECT statements using UNION or UNION ALL operator.
  3. Select the desired columns and arrange them in the required order.
bannerAds