Solved

change column order in Mysql Query browser

Posted on 2009-05-19
4
1,471 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
Comment Utility

select co3, col1, col2 from yourtable 

Open in new window

0
 
LVL 14

Expert Comment

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

Author Comment

by:andieje
Comment Utility
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
Comment Utility
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

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…
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

763 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

9 Experts available now in Live!

Get 1:1 Help Now