How to merge tables in navicat

Applicable operating systems: Windows, macOS, Linux

Applicable Navicat products: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat Premium

Applicable Navicat version number: All

Note: The structure of these two tables must be the same.

Recommended tutorial: MySQL introductory video

If the two tables are In the server, you can use data synchronization to merge tables.

Version 11.2 or below

1. In the General tab, select one table as the source table and another as the target table .

　2. In the Advanced tab, uncheck Delete Records and click Start.

　3. The target table will become the merged result table.

Version 12 or above

1. In the Options tab, uncheck Delete Record or Delete, and click Next.

　2. Select one table as the source and another as the target, and click Next.

　3. Click Deploy.

　4. Click Run.

The target table will become the merged result table.

If the two tables are in other formats (for example: Excel, text...), you can import one file into a new table, and then import another into the same table.

The above is the detailed content of How to merge tables in navicat. For more information, please follow other related articles on the PHP Chinese website!