rajchahal Posted July 9, 2008 Share Posted July 9, 2008 hi I'm running mysql5 with mysql administrator 1.2.12 The fields listed are id, data1, data2 I want data2 to appear before data1.. is this possible without deleting the table and starting again? thanks Link to comment https://forums.phpfreaks.com/topic/113923-changing-field-order-of-appearance-mysql-in-table/ Share on other sites More sharing options...
fenway Posted July 9, 2008 Share Posted July 9, 2008 You can, but why does it matter? Link to comment https://forums.phpfreaks.com/topic/113923-changing-field-order-of-appearance-mysql-in-table/#findComment-585418 Share on other sites More sharing options...
rajchahal Posted July 9, 2008 Author Share Posted July 9, 2008 thought you might ask me this-- I'm using a wizzard in dreamweaver that picks out the fields from the database in this order. Dreamweaver then creates a form in the same order as the filelds in the database, which is in the incorrect order. So I have to manually move things around. Just figured if I could change the order in mysql it would speed things up for me. Thanks Link to comment https://forums.phpfreaks.com/topic/113923-changing-field-order-of-appearance-mysql-in-table/#findComment-585546 Share on other sites More sharing options...
fenway Posted July 9, 2008 Share Posted July 9, 2008 You can issue an ALTER statement with MODIFY, and then specify BEFORE/AFTER. Link to comment https://forums.phpfreaks.com/topic/113923-changing-field-order-of-appearance-mysql-in-table/#findComment-585585 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.