SmartMySQL SQL Query Editor has integrated AI algorithms which can speed up your work and integrated Query optimizer help to fine-tune slow queries while developing them and it doesn’t require Expert level DB knowledge.  Please watch the following demo video who SmartMySQL help to save more than ten times for your MySQL development time.

Smart MySQL key features Quick Demo

 

Here you can write SQL commands that you want to execute. StartMySQL provides different ways to enter
• Directly type the SQL commands into the SQL window.
• Drag the table from object browser to the SQL window.
• Open saved SQL script by using the File/Open option.
• Open SQL script from favorites.
• Insert SQL templates from Edit/Insert.

Multiple Queries:

In the SQL window, you can enter various SQL commands separated by ‘;’. SmartMYSQL treats one query up to ‘;’ and give different result window for each query.
If any Query is not using an index, it can identify after entering “;” and displays warning icons.  Also, It can display Syntax error icon if the query has syntax error after entering “;” it highlights syntax error after running the query.
It is also displayed Foreign Key errors Dead Lock errors which other tools can’t show in the error message.
It has integrated Smart-Auto complete help you to reuse historical queries, Frequently executing queries and Favorite queries with simple short cuts (CTRL+Shift+H / CTRL+Shift+ Q / CTRL+Shift+F). It also helps to complete table names, column names, SQL keywords and DB objects in the auto-complete list.

SmartMySQL provides five types of query execution options

1. Execute Query
2. Execute and Edit Query
3. Lock-Free Query execution
4. Bulk Query execution
5. Bulk INSERT/UPDATE queries execution

You can execute SQL queries in SMARTMYSQL following ways.

• Place cursor on a query you want to execute in Query editor and then press F9  or select  Edit/Execute/Execute Query option or click on the green arrow icon to execute a single query.
• There is an option to execute multiple queries once if you select all queries and then press double green arrow icon or select  Edit/Execute/Execute All  Queries or press CTRL+F9. All  Queries execute one by one and provide a result set in separate result tabs for each query.
• If you want to avoid the transaction locks while running queries then select  Edit/Execute/Lock-Free Execution (or) Click on the green arrow with a lock icon.
• You want to execute Bulk SQL queries in DB server without the need of query response like executing bulk inserts/updates  SMARTMYSQL provides  Edit/Execute/Bulk Execute (or) click on the double blue arrow icon.

In case you want to stop executed query in SMARTMYSQL whenever you execute a query that corresponding icon  replaced by stop just click on stop icon for stopping

 query execution.

SmartMySQL highlight SQL syntax for ease of use. In SmartMySQL having certain defaults, you can configure your own highlight font and editor settings by selecting tools ->Preferences->Fonts.

It Also highlights slow queries and Query syntax errors in the Query browser

Slow Query warning highlight:-

If any Select Query doesn’t use index then the SmartMySQL show warning icon and if you click it will go to Query Optimizer and give optimal index for the slow query.

Also, It alerts as a warning if any query goes for a full table scan.

Query syntax error highlight:-

If any query syntax error then the SmartMySQL can identify it and show an error icon. If you execute it then it will show exactly where is the error in the query.

You need to connect with MySQL server before you will perform any activities. You can connect to MySQL server in the following  ways.

• Select  File->Connection->New connection using current settings(or press Ctrl+N)  to open the same server of the current server without any details.
• Select  File->Connection->New connection (or press Ctrl+M)   it will open connection window. Once enter the all server details click on connect to new MySQL server.

• Select File->Modify->Disconnect(or press Ctrl+F4)  to close the current connection.
• Select File->Modify->Disconnect All to disconnect to close the all open connections.

 

With SmartMySQL” you’ll be able to get pleasure from an excellent feature of multiple editor tabs within the SQL window. It allows you to open many files with logically separate your queries between the tabs. Press Ctrl + T to open a  new SQL editor tab. The focus may be modified between editor tabs mistreatment Ctrl + Page UP and Ctrl + Page Down buttons and also the active editor tab can be close with Alt + L.

We can open all altered objects like views, stored procedures in the query editor tab. In SmartMySQL we can manage

multiple query editor tabs by click on drop-down button on the extreme right.

 

SmartMySQl provides  a smart feature like simply drag the table to query editor

select  Edit->Advanced to use the advanced SmartMySQL features.

• Edit->Advanced ->Make Selection Upper Case(or  press Ctrl+Shift+U) to change the selected text to upper case.
• Edit->Advanced ->Make Selection Lower Case(or  press Ctrl+Shift+L) to change the selected text to lower case.
• Edit->Advanced ->Comment Section(or  press Ctrl+Shift+C) to comment the selected text.
• Edit->Advanced ->Remove comment from selection(or  press Ctrl+Shift+R) to remove  the comments from the selected text.
• Edit->Find->Go to(or press Ctrl+G)  here just enter the line number to go to the required line in the SQL window.

Select Edit->Insert Templates(Ctrl+Shift+T)  to insert readily available SQL statements.

Now choose the SQL statement to insert the template and click on the Insert button. The template is traced within the Query Window. Now, you’ll modify the SQL statement as necessary.

SmartMySQL provides  New features for saving developers time with Smart Auto-Complete feature.

 

• Auto-Complete can display all Tables names, column names other objects, also It displays historical Queries (Ctrl+Shift+H) , Frequently executing Queries(Ctrl+Shift+Q) and Favorite Queries(Ctrl+Shift+F) in the auto-complete list. It is one of the best way to reuse your queries.
• Automatically generate JOIN conditions:  If you type “JOIN” and select next table from the auto-complete list it automatically generates JOIN condition.  There are some other ways to write your queries by dragging the tables into a  query browser where usually write SQL queries with JOIN condition. You just need to add filter conditions.

In the above example, the developer dragged film_actor, actor and film tables into the query browser and the above query was generated. You can also modify select clause and add where & group by clause. This approach helps to speed up your query writing time.

• If a user selects a table and drops the table into Query browser area, it generates a select query for the table. Dragging another table into the query creates a newly built query with a join.

Dragging and dropping the actor, film_actor and film tables generates the above query.

• It also identifies joining-tables and automatically generates join-conditions while writing SQL queries. For this feature simply write select with join  after  joining table name automatically  display join condition

• If you add your frequently-executed queries in favorites, then the favorites show in auto-complete. If you select your favorite query name then it displays your favorite query.

In the example, I have saved a favorite name “RQ (Running queries)” for the query- “select * from information_schema.PROCESSLIST where COMMAND <> ‘sleep’ order by time DESC”. After select your favorite it places the query.

From this example, you just click on RQ automatically paste the running queries command in the query editor

• SmartMySQLcan identifies Query syntax error before execution also and highlights with red color Triangle.

 

• SmartMySQL highlights syntax error areas after query execution. When a user executes any query which has a syntax error, SmartMySQL points out syntax error areas in the query.

In the above example, SmartMySQL has identified where the syntax error is in the query and highlighted it with the red background color. You can simply check and correct the query. Further, during such instances, SmartMySQL shows Google, Yahoo and Bing search engines icons. By clicking any of the icons, SmartMySQL automatically opens search engine results relating to the error message.

Then you can do your R&D and fix your error. These features are necessary for reducing development time.

• SmartMySQl also provides whenever you type database name followed by “.” after that the objects under that database appear in below pop up and you can select from that window by using arrow keys.

 

Smart MySQL query beautifier: Query formatting helps to understand the query in a better way. The SmartMySQL tool can query formatting in Free version.

in query tab. With only one click we can format the complex content queries as well.

Select EDIT->Formatter->From this option we will choose different options.

• EDIT->Formatter-> Format current query(or press F12) to format a particular query from list of queries, just place the cursor on that query. With this option, only the current query will be formatted.
• EDIT->Formatter->Format  Selected query(or press Ctrl+F12)  to format only selected query from a list of queries, just select the particular query and click on the option. With this option only selected query would be formatted.
• EDIT->Formatter->Format  All Queries(or press Shift+F12) to format all list of  queries in the query tab

 

after formatting

 

In the query editor, we can find parenthesis matching by simply place the cursor after parenthesis then the parenthesis and its matching parenthesis will be highlighted.

 

History tab stores the all executed MySQL queries in server with execution date and time.