To rearrange columns in MySQL you can use the following snippet.
ALTER TABLE TABLENAME MODIFY COLUMN COLUMNNAME TYPE AFTER COLUMNNAME
2 thought on “How to rearrange columns in MySQL”
Leave a Reply
You must be logged in to post a comment.
All the Code Snippets and Samples you need
To rearrange columns in MySQL you can use the following snippet.
ALTER TABLE TABLENAME MODIFY COLUMN COLUMNNAME TYPE AFTER COLUMNNAME
You must be logged in to post a comment.
RT @CodeSnippetsNET: How to rearrange columns in #MySQL http://t.co/bBue7I8RrB #php #html #js #javascript #jquery #css
RT @CodeSnippetsNET: How to rearrange columns in #MySQL http://t.co/bBue7I8RrB #php #html #js #javascript #jquery #css