ALTER TABLE MODIFY SecondFileName INT/VARCHAR/??? AFTER LastFieldName.
ALTER TABLE MODIFY OldLastFieldName INT/VARCHAR/??? AFTER FirstFieldName.
Just leave the type of field the same an place the "AFTER" keyword and the
field you want it after.
Check out...
http://www.mysql.com/doc/en/ALTER_TABLE.html
Roger
> -----Original Message-----
> From: James Moe [mailto:jimoe@stripped]
> Sent: Monday, May 12, 2003 9:55 PM
> To: mysql
> Subject: Re: ALTER TABLE ORDER
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Mon, 12 May 2003 16:27:34 -0600, Kory Wheatley wrote:
>
> >How with the ALTER TABLE command do you switch field position, I want
> >the second field to be my last field and my last field to be my second
> >field?
> >
> You don't.
> New columns are always appended to the end when using ALTER TABLE.
> To change the order you must dump the table, edit the CREATE
> TABLE entries, and
> reload the table with the modified file.
>
>
> - --
> jimoe at sohnen-moe dot com
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 5.0 OS/2 for non-commercial use
> Comment: PGP 5.0 for OS/2
> Charset: cp850
>
> wj8DBQE+wFBgsxxMki0foKoRAgZiAJ953oiNK4cqED36Uu45cSsaPfkX2ACZAZqt
> QFgQkquL7G9+HDFPWiKt3dY=
> =HuJV
> -----END PGP SIGNATURE-----
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
