Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides

FAQ

It is currently Mon Aug 02, 2021 7:24 pm

ROOT ‹ Website Development and Databases ‹ Mysql ‹ Mysql - Change position of a column after another column

Mysql Application & Query Optimization, Questions, Indexes, Bugs.

Post a reply

2 posts • Page 1 of 1

Mysql - Change position of a column after another column

« Previous topic | Next topic »

Author

Message

admin

Post subject: Mysql - Change position of a column after another column | Posted: Fri Aug 20, 2010 5:03 am

Site Admin

Joined: Mon Aug 03, 2009 8:43 am
Posts: 104

Mysql - Change position of a column after another column

The column order in mysql is not very important in most of the cases, since the SELECT statement can create another column order, one specifically for the application being developed (but not the "SELECT *" statement).

But in cases where order is important, this command will change the position of "column_two" after "column_one".

Code:

mysql> ALTER TABLE table_name MODIFY column_two INT(11) UNSIGNED AFTER column_one; 

_________________
VPSie - SSD VPS servers in AMS-IX, LINX, DE-CIX
https://vpsie.com

			Tweet
Follow @IvordeCom

You might also be interested in:
Mysql change column's default value. Mysql: add column to table. Mysql add Unique index to a table column. Mysql remove column from an existing table. How to calculate mysql time difference between unix timestamp column and now() format. Mysql change root password. Mysql> select records that have date/datetime column equal to today's date. MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13). Rename MySql table. MySql rename table.

Top

sonee4

Post subject: Re: Mysql - Change position of a column after another column | Posted: Fri Oct 08, 2010 1:41 am

Joined: Thu Oct 07, 2010 11:25 pm
Posts: 3

Thanks for suggesting this great and important code and post.

Top

Post a reply

2 posts • Page 1 of 1

Topics		Author	Replies	Views	Last post
Topics related to - "Mysql - Change position of a column after another column"
	Mysql change column's default value	debuser	0	2407	Thu Aug 12, 2010 3:43 am debuser
	Mysql: add column to table	debuser	1	3741	Fri Oct 08, 2010 1:38 am sonee4
	Mysql add Unique index to a table column	debuser	0	2837	Fri Aug 06, 2010 10:01 am debuser
	Mysql remove column from an existing table	debuser	0	1974	Fri Aug 06, 2010 10:06 am debuser
	How to calculate mysql time difference between unix timestamp column and now() format	mandrei99	0	9226	Fri May 31, 2013 4:10 am mandrei99
	Mysql change root password	mandrei99	0	2454	Tue Feb 10, 2015 6:50 pm mandrei99
	Mysql> select records that have date/datetime column equal to today's date	admin	0	3611	Tue Nov 22, 2011 9:40 am admin
	MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)	debuser	0	2857	Mon Feb 22, 2010 1:43 pm debuser
	Rename MySql table	debuser	1	2004	Fri Oct 08, 2010 1:36 am sonee4
	MySql rename table	admin	2	2473	Mon Nov 28, 2011 3:39 am Darwin

Who is online

Users browsing this forum: No registered users and 1 guest

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:

Channel list

ROOT ‹ Website Development and Databases ‹ Mysql

Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]