Changing MySQL Field Order
Moderator: General Moderators
Changing MySQL Field Order
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?
-
omega-systems
- Forum Newbie
- Posts: 14
- Joined: Tue Sep 27, 2005 5:01 am
- Contact:
Re: Changing MySQL Field Order
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
Regards,
Michael.
Project Manager
Omega Systems Ltd
Email: info@omega-systems.biz
ICQ: 264962449
MSN: omega-systems@hotmail.com
AIM: OmegaSys Ltd