To *move* a column to a particular position:
ALTER TABLE `user` MODIFY COLUMN `permission` int(10) AFTER `password`
To *move* a column to the beginning:
ALTER TABLE `user` MODIFY COLUMN `permission` int(10) FIRST
Home
>
Rearrange/move MySQL Table Columns Rearrange/move MySQL Table Columns
No Comments »
No comments yet.
RSS feed for comments on this post. TrackBack URL
Leave a comment
Back To Top
Back To Previous Page
Author Bio
Hamid Alipour is a partner in Codehead, LLP with his wife, Tess. Hamid speaks 12 markup and programming languages [Yes, 12: PHP, CSS, Ajax, JavaScript, HTML/XHTML, Java, Python, C/C++, ASP, Visual Basic, Scheme and Action Script]; has a penchant for solving the unsolvable; an affinity for clean, hand-written code and is a Zend Certified 
Services
Blog
Tools
About
Contact
Blog Home