Skip to content

Instantly share code, notes, and snippets.

@boy3vil

boy3vil/gist:0b2e319485b2957968fc73659fa632bb

Created February 6, 2017 01:42
Show Gist options
  • Save boy3vil/0b2e319485b2957968fc73659fa632bb to your computer and use it in GitHub Desktop.
Save boy3vil/0b2e319485b2957968fc73659fa632bb to your computer and use it in GitHub Desktop.
Download ZIP
Change the column position of MySql table
Raw
gistfile1.txt
+----+------+-------+----------+
| id | name | email | password |
+----+------+-------+----------+
to
+----+----------+------+-------+
| id | password | name | email |
+----+----------+------+-------+
ALTER TABLE table_name MODIFY password varchar(20) AFTER id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment