change column order in Mysql Query browser

Posted on 2009-05-19
Last Modified: 2012-05-07
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?
Question by:andieje
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 14

Expert Comment

ID: 24423480

select co3, col1, col2 from yourtable 

Open in new window

LVL 14

Expert Comment

ID: 24423539
in query browse can you move column head to the left or right

Author Comment

ID: 24425320
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

Accepted Solution

andieje earned 0 total points
ID: 24493945
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL 5.6.30 - daily outages 46 68
Inserting data into database 10 47
Using PhpMyAdmin (or Mysql) for a find and replace operation 11 44
Delete image(s) associated with record(s) 16 30
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (, A SQLite Tidbit: Quick Numbers Table Generation (…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question