Copy data from one MySQL query to another MySQL table

by

Want to copy data from one MySQL query to another MySQL table?

Using DBCopier, a native GUI tool, you can copy data from one MySQL query to another MySQL table easily and fast, just a few mouse clicks!

Support Windows, Linux, macOS

Here you can download and install DBCopier.

Copy data from one MySQL query to another MySQL table

Choose source/target MySQL database and logon.

copy data between MySQL (MariaDB, Percona) - Choose MySQL and logon

Click “Convert From Query” at task dialog.

Copy data from one MySQL query to another MySQL table - Task Window

then show the wizard.

1. Run a SQL Query.

copy data from one MySQL query to another MySQL table - Run Query see ResultSet

2. Select a destination table and config fields.

load data from one MySQL query to another MySQL table - select table

3. Preview data.

transfer data from one MySQL query to another MySQL table - preview

4. Import.

convert data from one MySQL query to another MySQL table - import query results

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.


More about DBCopier – the tool to copy MySQL data to another MySQL

30-day free trial Download DBCopier