There's a facility in MySQL Workbench's EER Modelling mode to write an SQL script that's stored with the model. But I've looked all over the place and can't see any way of executing such a script, other than by copying and pasting it into a window of the query mode. There's a menu item Scripting/Run Script, but it doesn't seem to actually do anything. Surely there must be some application of the scripts section of the model beyond just storing SQL text?
Execute script from MySQL workbench EER model?
1.5k Views Asked by Jules At
1
There are 1 best solutions below
Related Questions in MYSQL-WORKBENCH
- Deployment through app engine, cloud sql database, problem connecting with server code, doesn't connect
- Creating Relationship Creates Additional Columns in MySQL Workbench
- MySQL Workbench [BUG]
- Error in releasing pool connection in node project
- MySQL Workbench not showing Apply and Revert buttons while creating a table
- How I can store multilevel comments of user in MySQL dB
- MySQL Workbench gives duplicate warnings when there should not be any
- How to Revert import Schema in Mysql Work Bench
- Error 29 on mysql workbench, how to fix it?
- I want to call a my secure Rest API created in Spring boot using Javascript but its giving error
- Statement incomplete in mysql
- Load data local infile with double quotes and commas in fields
- There was an error while applying the SQL script to the database
- MYSQL won't allow me to create a table
- I am trying to connect to remote server using mysql workbench but i can't. I am using ubantu 22
Related Questions in EER-MODEL
- MySQL EER database model that stores download information?
- Can a relationship type attribute be a derived attribute?
- How to convert EXCEL to SQL (I have 143864 row and 100 column in excel) total 48,316 KB
- ER Modelling - Subclass relationships & Relationship Entities
- SQL: How to model multiple n:m relations in ERM
- can a conceptual model have this?
- EER Diagrams, different symbols?
- EER Diagram, am I doing this right?
- Extract ORMLite Database documentation and schema
- What does the "C" symbol means in EER diagrams?
- EER diagram in mysql workbench
- How do I see the EER Model for an mySQL database I have created using DDL
- MySQL WorkBench EER model not show PK
- Unable to move (click and drag) entities in MySQL Workbench EER Diagram
- MySQL Workbench generate tables from EER Diagram
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Running arbitrary SQL code during forward engineering or synchronization is not possible. The only code that gets executed is the sql to create the objects and to fill tables with data specified in the Inserts section of the table editor.
Running an sql script in general is of course possible and also trivial. Simply open a connection to your server (you should have one created on the home screen, if not do this first). Then in the editor toolbar there's a button to open a script. Use that to open the file (if you have a separate sql file). If you want to run code that is stored in the model (as SQL file) you have to copy/paste it over.