A few things to improve
1) I didn't find way how to turn on auto-popup code completion list.
Manually trigger completion list by ctrl+space is very distracting and uncomfortable while typing code.
2) Column names in the code completion list are missing.
3) Auto uppercase for SQL keywords when typing would be very nice for code readibility.
4) Make 'Run current query' command execution even if the keyboard cursor is located after the last character of a statement. It doesn't work after I finish statement typing and every time I have to move the cursor to some character position of desired statement.
5) If I have code like this:
select 1;
show warnings;
It would be nice to have the name of the query result tab in this way:
select 1 | show warnings
Instead of this:
Result #1 (1x1) | Result #2 (3x0)
And make (cols x rows) optional.
6) Why NULL in the result set does have parenthesis ? (NULL) is a bit confusing according to the standard way the mysql client shows the result-set data.
7) Make bold font for primary column and key icons optional in the result-set. I prefer clean format of result-set data like in mysql client console.
1) That suggest popup gets displayed automatically when typing a dot.
2) Column names appear when you write one of the following combinations:
3) Auto-uppercase would drive me crazy. But you can click on the "Reformat" button (the icon with the white page on it), or just click Ctrl+F8. That uppercases all keywords and does some auto-indentation.
2) Column names appear when you write one of the following combinations:
... mytable.|
SELECT * FROM mytable AS a WHERE a.|
3) Auto-uppercase would drive me crazy. But you can click on the "Reformat" button (the icon with the white page on it), or just click Ctrl+F8. That uppercases all keywords and does some auto-indentation.
1) That suggest popup gets displayed automatically when typing a dot.
Why does it pop only when typing dot first ? It doesn't make sense. Very often I type statements which don't begin with dot. So why there is no auto-popup for these situations ?
2) Column names appear when you write one of the following combinations:
... mytable.| SELECT * FROM mytable AS a WHERE a.|
But they don't appear right after the SELECT. This is the most frequent way of defining columns
3) Auto-uppercase would drive me crazy.
Why ? The keyword uppercase is a standard of SQL syntax. For what reason is it good to have the code format like this ?:
select * from mytable as a where id=1;
But they don't appear right after the SELECT. This is the most frequent way of defining columns
Ok, to say it more accurately: They appear only when you have already defined table name. And you have to use table identifier. But often there are situations when I start define columns before the defining the table name.
It may show all existing column names within selected db. If I for example start typing 'fir_' the completion list pops up and shows also all column names beginning with 'fir'.
The point is that I know which column from which table I want to define before I type it in the editor and reach the FROM clause :)
The point is that I know which column from which table I want to define before I type it in the editor and reach the FROM clause :)
Please think of users with large databases here. It would take various seconds if not even minutes to retrieve all columns from all tables in a database. Just make a test and run such a query:
SELECT * FROM `information_schema`.`COLUMNS` WHERE `TABLE_SCHEMA`='yourbiggestdatabase' ORDER BY `TABLE_NAME`
Please login to leave a reply, or register at first.