Want to copy data from a MySQL query to a MySQL table?
Using Withdata software DB Copier, a MySQL data transfer for Windows, MacOS, and Linux, you can copy a MySQL query results to a MySQL table easily and fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
Download DBCopier
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
Copy data from MySQL query results to MySQL table
Login to source and target MySQL -> Enter MySQL auery -> Set target MySQL table -> Copy MySQL data
Choose source/target MySQL database and logon.
Click “Convert From Query” at task dialog.
then show the wizard.
1. Enter a MySQL SQL Query.
2. Select a destination table and config fields.
3. Preview data.
4. Copy MySQL query results data to MySQL table.
Copy a MySQL query results to a MySQL table in command line
Save “Copy MySQL query to table” session, then you can:
- Copy MySQL query to table in Windows command line.
- Copy MySQL query to table in Linux command line.
- Copy MySQL query to table in macOS command line.
Set scheduled tasks for coping a MySQL query results to a MySQL table
You can schedule and automate this “MySQL Copy” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.