HeidiSQL - How to Select Individual Columns Explicitly into Query Window? -

HeidiSQL - How to Select Individual Columns Explicitly into Query Window? -

apologies if title unclear, couldn't think of concise way express this.

i'm wondering if heidisql has simple functionality create new select query explicitly lists every column contained in table. in ms sql management studio (and believe in mysql workbench) can done right clicking table , clicking 'new select query' or along lines.

this can useful creating queries off tables containing many columns, not columns desired, or handful of transformations required. alternative involves typing out every single column name individually. creating 'create table' query comes close want, includes column type descriptor info needs manually deleted.

so illustration want is, instead of:

select * mytable

i need:

select id, name, location, date, value1, value2 mytable

is there quick , easy way utilize ui generate in heidisql?

i had same problem ...

solved installing older version of heidisql.

for older versions, show finish "selects columns" in log field.

update 2015-03-18:

i total select doing simple update on table field.

image: http://pt-br.tinypic.com/view.php?pic=2nqtemr&s=8

sorry english, don't speak english language nice, i'm brazil = /.

heidisql