auto complete

jeancarlosnx's profile image jeancarlosnx posted 4 weeks ago in General Permalink

Hi guys, I would like to know if there is any command that shows the columns for auto completion in HeidiSQL, without having to enter the table name first, as is in the print screen below


ansgar's profile image ansgar posted 4 weeks ago Permalink

Yes, you can use a table alias:

SELECT * FROM audits_osm AS ao WHERE ao.

You can also leave the "AS" keyword away:

SELECT * FROM audits_osm ao WHERE ao.

HeidiSQL works with both of these, and will show the suggestions right after the alias, as if you typed the table name.

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