PHP myAdmin - Change Field Order (Move Up Or Down)

Question

How do I change the order of my table fields without deleting the field and re-inserting it, using PHP myAdmin?

Populus · Answer 1 · 2014-01-02T14:57:17.293

75

ALTER TABLE `table_name` MODIFY `column_you_want_to_move` DATATYPE AFTER `column`

DATATYPE is something like DATETIME or VARCHAR(20) ..etc

edited Jan 02 '14 at 14:57

answered Apr 15 '11 at 05:45

Populus

7,470
3
38
54

For me, it must be: etc MODIFY COLUMN `column_you_want_etc` – cssyphus Nov 24 '13 at 03:08

TecBeast · Answer 2 · 2015-09-14T03:20:59.647

41

If you have phpMyAdmin 4.0.0+, you can use the phpMyAdmin Feature under Structure:

edited Sep 14 '15 at 03:20

answered Nov 26 '14 at 13:42

TecBeast

930
8
16

1

It is only work since version 4.0, phpMyAdmin. I checked phpMyAdmin Version 3.5.1 and there was no such function. – Yevgeniy Afanasyev Sep 14 '15 at 00:12

score 24 · Answer 3 · answered Oct 05 '12 at 08:45

24

Something like this will help

ALTER TABLE Person MODIFY COLUMN last_name VARCHAR(50) AFTER first_name;

This will move last_name right after first_name in order.

answered Oct 05 '12 at 08:45

Ashish

241
3
2

What if you want to make the column the first column? Ie, so it's not AFTER anything. I tried `"... BEFORE current_first_col"` but it doesn't recognise BEFORE. – Max Williams Apr 17 '13 at 09:43
3

Aha, just answered my own comment - the syntax is `ALTER TABLE Person MODIFY COLUMN last_name VARCHAR(50) FIRST;` to make it the first column. – Max Williams Apr 17 '13 at 09:44

score 9 · Answer 4 · answered Aug 23 '13 at 19:30

9

Since version 4.0, phpMyAdmin has a "Move columns" dialog in Structure, that permits you to graphically move columns in the structure.

answered Aug 23 '13 at 19:30

Marc Delisle

8,879
3
29
29

It isn't actually moving the columns. Go to other browser and see that the columns order are the same after teh change. – machineaddict Sep 12 '13 at 10:38
1

Well, it's working for me, actually moving the columns. – Marc Delisle Jan 02 '14 at 13:37

score 9 · Answer 5 · answered Dec 26 '09 at 02:10

http://dev.mysql.com/doc/refman/5.0/en/change-column-order.html

From the Aforementioned Source:

If you decide to change the order of table columns anyway, you can do so as follows:

Create a new table with the columns in the new order.
Execute this statement:

mysql> INSERT INTO new_table -> SELECT columns-in-new-order FROM old_table;
Drop or rename old_table.
Rename the new table to the original name:

mysql> ALTER TABLE new_table RENAME old_table;

score 4 · Answer 6 · edited Nov 24 '11 at 00:49

4

alter table table_name modify column col_name type after col_name

edited Nov 24 '11 at 00:49

animuson

53,861
28
137
147

answered Oct 14 '11 at 20:41

Cruz

41
1

score 3 · Answer 7 · answered Feb 16 '19 at 21:57

3

It's simple. Just go to PHPmyadmin, click on your database, then click table. Then click on structure. Below the table look for the button, "Move columns". Click and order the columns the way you want.

answered Feb 16 '19 at 21:57

Joseph Adegbola

61
7

score 1 · Answer 8 · edited Mar 20 '14 at 02:44

1

Another alternative:

CREATE new_table SELECT columns-in-new-order FROM old_table;

edited Mar 20 '14 at 02:44

Qantas 94 Heavy

15,750
31
68
83

answered Mar 20 '14 at 02:23

user2145716

11
1

score 1 · Answer 9 · edited Sep 07 '15 at 19:04

1

if you have MySQL Workbench you can easily reorder columns using mouse, graphically.

Just connect to your database, select your table and after right click, alter table and then drag columns to reorder them.

edited Sep 07 '15 at 19:04

skobaljic

9,379
1
25
51

answered Mar 09 '15 at 07:16

Peyman abdollahy

799
1
8
18

PHP myAdmin - Change Field Order (Move Up Or Down)

9 Answers9

From the Aforementioned Source:

Linked