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.

Shortcut for converting star notation to a list of all table columns?

bpeikes's profile image bpeikes posted 1 month ago in General Permalink

I've used other tools that had a keystroke that you could use after typing in a query with a X. in it that would expand the X. to a comma delimited list of columns for the table. For example, you would type

SELECT t1.*
FROM table_name t1

And then put the cursor after the * and hit something like shift-enter, and it would change the text to:

SELECT t1.id, t1.name, t1.description, t1.other_column
FROM table_name t1

Does HeidiSQL have this functionality? I was looking around for it, but couldn't find anything.

Thanks!

ansgar's profile image ansgar posted 1 month ago Permalink

Not directly. You can alternatively select some columns from the currently selected table in the helpers box, and drag them into the editor:

Description

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