Want to import data from each table in a SQL file to a separate MySQL table?
Try Withdata FileToDB, a SQL to MySQL converter, Import each table data in a SQL file to a separate MySQL table, Easy 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.
- Import SQL to MySQL locally and privately, avoid uploading SQL file(s) to online services.
- Support Windows, Linux, and macOS.
Import data from each table in a SQL file to a separate MySQL table
Select tables in SQL file -> Set MySQL tables -> Import SQL data to MySQL
Choose MySQL and logon.

Click “Wizard – 1 File To N Tables” at task dialog.

Select the “SQL” file type.

then show the wizard.
1. Open a SQL file, select tables.

2. Show existing MySQL tables, choose “Import Type”.

3. Set MySQL tables.

4. Show summary, set “Convert Rows”.

5. Import data from each table in a SQL file to a separate MySQL table.

View imported data in MySQL table

More about SQL file to MySQL converter
See Video: Import each table data in a SQL file to a separate MySQL table at one time

