Re: Is it Possible to Run Insert Query on Workbench

[Anil Kumar]

Reference : WorkBench Table Inserts Tab.

This tab does not allow to Paste an already existing Insert statement in a notepad or .sql file.

I have more than 200 lines of Insert Data already available as .sql file (Table's initial data's)

How can I paste or import this Insert sql statement to this tab so that I don't have to type in all the data again here. So that I can avoid typing errors as well as save time.

Any help will be appreciated as this will save my time a lot. I have to do similiar Inserts for different tables (my initial settings data)

I prefer/want to create SQL statements from MySql WorkBench thru the export option (along with the Inserts) to create database and Tables with Initial data's in the table.

Thanks & Regards