-->APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse ![Sql editor mysql Sql editor mysql](/uploads/1/2/5/8/125871324/833531372.png)
Use the SQL Editor to edit existing stored procedures, functions, triggers, and SQL scripts. This window opens when you open any of those objects. If you want to create a new SQL statement to run against your data source, use the SQL Pane of Query Designer.
MySQL Workbench 64-bit delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. Closed as off-topic by Andrew Barber Apr 9 '14 at 20:11. This question appears to be off-topic. The users who voted to close gave this specific reason: 'Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.'
![Sql editor mysql Sql editor mysql](/uploads/1/2/5/8/125871324/833531372.png)
The SQL editor provides many useful SQL text-editing features, including:
- Color coding of SQL keywords to minimize syntax and spelling errors.
- Generating skeletal stored procedures and triggers.
- Providing useful editing functions, including cut, copy, paste, and dragging operations.
- Changing the editor's behavior (by selecting Options from the Tools menu) to modify virtual spaces, word wrap, line numbers, and tab size.
- Helping manage debugging breakpoints.
Note
The SQL Editor does not have IntelliSense prompting.
When editing SQL statements, certain Transact-SQL statements are enclosed in a box surrounded by a thin line. This helps to visually break the SQL code into command sections, and identifies blocks of SQL statements that can be graphically designed using Query Designer. For more information on using Query Designer, see Design Queries and Views How-to Topics (Visual Database Tools).
See Also
Does anyone have any good ideas as to native MySQL GUI clients for Ubuntu?
So far I've tried MySQL Workbench, which never seemed to work properly, phpMyAdmin which I found a bit slow, and Navicat which is a windows port and runs under wine, but none of these is perfect. In an ideal world, I'm looking for something like a native version of navicat.
richzillarichzilla
11 Answers
Sadly, you can't find these in the Ubuntu Software Centre in later versions of Ubuntu any more. This is because these two pieces of software have reached their end-of-life, and are no longer supported.
MySQL Workbench is probably the most complete tool, but a bit sluggish according to me.
I prefer 'MySQL Query browser' and 'MySQL Administrator'. These two can do all basic stuff, and are very user friendly.
W. GoemanW. Goeman
I like Emma. Emma is an open source project that isn't developed by Oracle.
Community♦
jetjet
I use a free tool Valentina Studio, is FREE, works on 32/64 bit Linux, Windows and Mac OS X. Is the best way to transform your data into meaningful information; create, administer, query and explore Valentina DB, MySQL, Postgre and SQLite databases http://www.valentina-db.com/en/valentina-studio-overview
ahmad dhaybiahmad dhaybi
GUI tools that have not been mentioned here, that I know work under Linux without WINE:
- DBeaver http://dbeaver.jkiss.org/ (Java, GPL)
- Squirrel http://www.squirrelsql.org/ (Java, LGPL or GPL)
- ocelotgui https://github.com/ocelot-inc/ocelotgui (C++, GPL)
Disclosure: I work for Ocelot.
Peter GulutzanPeter Gulutzan
I know the answer is already accepted but I felt I should add SQLYog to this list anyway since it is such a powerful tool... There is no official build available for Linux but it works quite well on Wine.
NikhilNikhil
Another alternative is Tora (an opensource Qt multi-platform application).
Jaime M.Jaime M.
I use Adminer. It's very lightweight and with a clear interface.
Can be installed with
sudo apt-get install adminer
But if you want newer versions you should install manually:
Eyal LevinEyal Levin
MySQL workbench does work on Ubuntu 11.xx but it will hang at some of the loading splash screens. You just need to use Alt+F4 to close the splash window and it will continue.
scottfennellscottfennell
dbeaver (https://github.com/serge-rider/dbeaver) is good option aswell, i would disadvice mysql workbench because it is really unstable (on 16.04 and 14.04)
WouterWouter
I solved this problem with the following method (I used to install quanta+ 3.5 in ubuntu 12.04. In the same repositories you can find mysql gui tools):
The tutorial is in this blog article.
Follow the tutorial, and replace:
with:
but maybe it is
mysql-gui-tools
, but i'm not sure. user76204
yQyyQy
One possibility is using SQLExplorer, either as an Eclipse plugin or a standalone 'RCP' application. I use it as a plugin, but you can download a Linux standalone version, too. To start the standalone version extract it and execute the sqlexplorer file.
It's being actively developed (last version was in April 2013) and for many people IDE integration is a plus.
EyalEyal
protected by jokerdino♦Aug 17 '13 at 13:16
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?