What Inserts tab does in MySQL Workbench EER Diagram Table Editing?

Question

I needed to insert some initial (default) data into a new database and I found this Inserts tab on MySQL Workbench EER Diagram table editing form

My assumption was that I can use it to insert initial (default) data that will get propagated to the database during synchronization (not sure how it will get merged with any existing data in the database though...). I added couple rows and synced model with an empty database, but no data was inserted.

So, my question is what this Inserts tab is for on the Table Editing screen?

I use MySQL Workbench 6.

P.S. If somebody can also point to an easy way to insert initial (default) data (except simply running a SQL script) I will appreciate it.

Thank you.

Answer 1

The data added on the INSERTs page is indeed thought to be like an initial set of (test)data. It doesn't consider existing data however. I think it is also only used if you do forward engineering, not on synchronization.

Other ways of inserting data always involve an SQL script, that's what the (text) API is about for SQL servers. But you can add scripts to your model too (see the overview page). They are not run automatically, however.