Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Is there any key like "Alt+/" in Eclipse when I'm writing SQL Query?

19774279's profile image 19774279 posted 9 years ago in General Permalink
For example, if I type "s", and press some keys, it will tell me all the Object begin which "s" such as "SELECT","SET" or some databases/tables begin with "s".
ansgar's profile image ansgar posted 9 years ago Permalink
Ah, you mean a completion proposal. Yes, HeidiSQL has such a thing. In a query editor, press Ctrl+Space to invoke it manually. Also when you type a dot - for example after a table alias - Heidi will propose you all column names in that table:
SELECT *
FROM mytable AS m
WHERE m.[!proposal opens]


Or all tables from a database:
SELECT *
FROM mydb[!proposal opens]
ansgar's profile image ansgar posted 9 years ago Permalink
eh, forgot the dot in the second example:
SELECT *
FROM mydb.[!proposal opens]
kalvaro's profile image kalvaro posted 9 years ago Permalink
BTW, there's a tiny exception to the auto-completion that's always bugging me:

SELECT mytable.x[proposal opens]
FROM mytable


SELECT foo.x[proposal opens]
FROM mytable foo


SELECT x[no proposal!]
FROM mytable


Not sure if there's a simple fix to this :-?

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.