Solved

change column order in Mysql Query browser

Posted on 2009-05-19
4
1,485 Views
Last Modified: 2012-05-07
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
Comment
Question by:andieje
  • 2
  • 2
4 Comments
 
LVL 14

Expert Comment

by:racek
ID: 24423480

select co3, col1, col2 from yourtable 

Open in new window

0
 
LVL 14

Expert Comment

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

Author Comment

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

Accepted Solution

by:
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
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikipedia.org/wiki/PHP  Very powerful.  But a…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

813 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now