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

bpeikes's profile image bpeikes posted 4 years 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

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.description, t1.other_column
FROM table_name t1

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


ansgar's profile image ansgar posted 4 years 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:


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