Re: changing column order in MySQL tables?

2001-11-03 Thread Bennett Haselton
At 04:26 PM 11/2/2001 -0600, Paul DuBois wrote: >At 2:12 PM -0800 11/2/01, Bennett Haselton wrote: >>How do you change the order of columns in MySQL tables? I assume the >>tables have a concept of column order, since the DESCRIBE command always >>lists the columsn in the order in which they wer

RE: changing column order in MySQL tables?

2001-11-03 Thread Carsten H. Pedersen
> How do you change the order of columns in MySQL tables? I assume the > tables have a concept of column order, since the DESCRIBE command always > lists the columsn in the order in which they were created. http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_5_0 / Carsten -- Carsten H. Pedersen keep

RE: changing column order in MySQL tables?

2001-11-02 Thread Bill Blowitz
in "C" so It's also in "C1". Next, alter the table & remove column "C" and lastly rename column "C1" to "C". bill;-) -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 2:27 PM To: Benne

Re: changing column order in MySQL tables?

2001-11-02 Thread Paul DuBois
At 2:12 PM -0800 11/2/01, Bennett Haselton wrote: >How do you change the order of columns in MySQL tables? I assume >the tables have a concept of column order, since the DESCRIBE >command always lists the columsn in the order in which they were >created. > >I figured that the place to look wou