Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of merging tables in navicat, which is very detailed and has certain reference value. Friends who are interested must finish reading it.

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

Navicat version number can be applied: all

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

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

Version 11.2 or below

1. On the General tab, select one table as the source table and the other as the target table.

2. On the Advanced tab, uncheck Delete record and click start.

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

Version 12 or above

1. On the 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 the other into the same table.

The above is all the contents of this article "navicat merging tables". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.