Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1588
  • Last Modified:

change column order in Mysql Query browser

Hi
When you use the table editor in query browser it displays the columsn in a particular order, presumably the order in which they are created. CAn i change the order in which they are displayed?
thanks
0
andieje
Asked:
andieje
  • 2
  • 2
1 Solution
 
racekCommented:

select co3, col1, col2 from yourtable 

Open in new window

0
 
racekCommented:
in query browse can you move column head to the left or right
0
 
andiejeAuthor Commented:
Hi
I'm not sure you have understood my question. I am on about the display of columns in the Table Editor. I can't see anything to move columns up and down in the display
0
 
andiejeAuthor Commented:
I could not find anything to change the column order. The best I could do was to recreate the table with the columsn in the desired order in the create statement
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now