?
Solved

change column order in Mysql Query browser

Posted on 2009-05-19
4
Medium Priority
?
1,532 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
[X]
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
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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

752 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