Quick "select * from table" options

[expired user #9218]'s profile image [expired user #9218] posted 9 years ago in Feature discussion Permalink
I suggest the ability to do a quick select * query

I noticed that very often I need to type "select * from " and I thought maybe HeidiSQL could do that for us.

1- Right click on a table, menu shows item "Select from table", which in effect creates a query "select * from the_table limit 100;" in a new query tab and runs it
2- If I have a Query tab open and only one word non-keyword is in it, HeidiSQL attempts to translate as "select * from the_word limit 100;" instead of trying to run it right away. If both "the_word;" and "select * from the_word limit 100;" fail, then HeidiSQL shows an error and puts "the_word" back in the query.

Hope someone will read this, thanks :)
vinnyjames's profile image vinnyjames posted 4 years ago Permalink

The data tab is the closest equivalent of this. I can't post images here yet but click on a table on the left and then look for a Data tab on the right.

If you sort this tab by PK descending it will remember that. Also has a nice regex search at the bottom.

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