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


If the title is not clear, then there is a short way to express it.

I 'I am thinking that HeidasQL has some simple functionality to create some new selected queries, which clearly lists each column contained in that table. In MS SQL Management Studio (and I also believe in MYSQL workspace), this can be done by just clicking on the right table and clicking 'New selection query' or clicking on something with those lines.

It can be very useful to make queries from multiple column-containing tables, where most columns are desired, or where some profit changes are required. Alternatively, each individual column name has to be typed individually by creating a 'Create Table' query that comes close to what I want, but it contains all column type descriptor information that should be manually removed .

For example, instead of:

MySQL> 
  Select from MyTable

I need it: 

  Selection ID, name, location, date, value1, value 2 from MyTable Is this quick and easy way to generate URL in hedyskl?   
  •   
  •   
  •     
  •  Click the related table in the database table  
  •  Click on the  tab  
  •   
  •  Choose the desired column  
  •  Right click, and select  Choose Generate ...  
    •   
     Like the following figure:

    Comments

    Post a Comment