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 Quote 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? Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.