Page 1 of 1

Changing MySQL Field Order

Posted: Tue Sep 27, 2005 4:04 pm
by PatrickE
Just because I'm an oganizational freak, I'd like to reorganize the fields in a MySQL database table without having to delete any. Is there any way to do this?

Re: Changing MySQL Field Order

Posted: Wed Sep 28, 2005 3:46 am
by omega-systems
you can create bkup table. using INSERT... SELECT statement to reorganize the fields in a MySQL database table.

Regards,
Michael.

Project Manager
Omega Systems Ltd
Email: info@omega-systems.biz
ICQ: 264962449
MSN: omega-systems@hotmail.com
AIM: OmegaSys Ltd