CODEWITHSUNDEEP
mysqlmysql-workbench
Trevor
Trevor

Reputation: 6689

MySQL Workbench Inserts

I am using MySQL Workbench 5.2.28 for designing my database schema. I need to insert default data into some tables which can be done using the "Inserts" tab. However, it seems like it only allows entering data manually, one row at a time. I have an OUTFILE with several hundred rows that I would like to insert.

Is this possible with MySQL Workbench? Would creating separate MySQL scripts for importing default data be a better approach?

Upvotes: 6

Views: 16488

Answers (4)

Jonas Aeschlimann
Jonas Aeschlimann

Reputation: 135

In the MySQL Workbench Version 6.2 you will find a Import Button which alows you to Import Inserts from a CSV File with "," as delemiter.

Upvotes: 3

rogue-ys
rogue-ys

Reputation: 1

You are right there is no way I know doing this automatically. The only thing you can do is to generate all your inserts scripts in a single time by doing a forward engeniering and then by copying the insert statements at the end of the generated script (You must check the option "Generate INSERT statements").

Upvotes: 0

Piaf
Piaf

Reputation: 137

Generate CSV (quoted if you have comas in values) in Excel for example, then just copy/paste all rows into workbench via 'inserts' tab for each table in model. Works with Workbench version 5.2.40.

Upvotes: 4

Trevor
Trevor

Reputation: 6689

I am now using separate sql scripts for inserting my data as there doesn't seem to be an easy way to add bulk inserts to MySQL workbench.

Upvotes: 5

Related Questions