Quick "select * from table" options
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 :)
Please login to leave a reply, or register at first.