mysql workbench - saving actions as scripts

Posted on 2011-04-26
Last Modified: 2012-05-11

If i am adding data to a database in mysql workbench is there anyway to create scripts of the corresponding insert statements for the data I have just inserted. I'm experimenting with something and i find i am entering and deleting the same set of data a lot and i keep entering the data manually. I was hoping mysql workbench could create a script of the inserts i had performed

Question by:andieje
    LVL 7

    Accepted Solution


    I don't know what version of MWB you're using, but you should be able to generate dumps by pressing ctrl + shift + G (File - Export - Forward Engineer SQL CREATE ... ).
    There's a checkbox at the bottom of the dialog 'Generate INSERT Statements for Tables'. This should be the way to go. Hope I understood your question correctly.

    Author Comment

    I'm in the sql editor window and i am adding data manually by clicking on the table and selecting 'edit table data'

    However i now see i can add data from the model window and generate insert statements as you suggested

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now