Reputation: 8806
I've been writing and running queries from within MySQL workbench's SQL Query Panel. However, sometimes I need to run a one-off command (e.g. adding indices) that I don't want to save.
Right now, I write it in the query file, run, then delete from the file. Can I open a command line within MySQL workbench to run these one-off commands? If not, is it okay if I open another database connection from my OS terminal alongside my MySQL workbench connection?
Upvotes: 8
Views: 18712
Reputation: 53830
Click the first item in the toolbar. The "SQL" with the "+" sign. You'll get a new query tab. If you don't want to save the new query, just don't click the Save icon. Close the tab when you're done.
Upvotes: 5