Changing MySQL Field Order

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
PatrickE
Forum Newbie
Posts: 10
Joined: Mon Sep 26, 2005 2:52 pm

Changing MySQL Field Order

Post 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?
omega-systems
Forum Newbie
Posts: 14
Joined: Tue Sep 27, 2005 5:01 am
Contact:

Re: Changing MySQL Field Order

Post 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
Post Reply