I am new to EER diagrams and visual database modeling.
I have a mySQL model (EER) that I created, which we send to engineers to create our databases with exported SQL.
When editing a table in EER, you can also insert data. In this case, I have an SQL statement that inserts 250 strange countries into a table.
How can I run this SQL script against my EER - or do I need to type each one manually?
Additional thought: Perhaps I can specify a stored procedure that should be executed when rebuilding the database?
source
share