Ivorde Unix/Linux/Database/Web/Mail Forum

FAQ

View unanswered posts View active topics
	It is currently Sat Feb 04, 2012 10:28 pm

ROOT ‹ Databases ‹ Mysql ‹ Mysql remove column from an existing table

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

Post a reply

1 post • Page 1 of 1

Bookmark this article:

Mysql remove column from an existing table

« Previous topic | Next topic »

Author

Message

debuser

Post subject: Mysql remove column from an existing table | Posted: Fri Aug 06, 2010 5:06 pm

Joined: Thu Aug 06, 2009 9:48 am
Posts: 90

Save on Delicious

The following command will remove an existing table's specified column and the data contained:

Code:

mysql> ALTER TABLE table_name DROP column_name;

As with any database/file delete/edit actions, it's recommended to have a backup. You never know when you meight need it.

Top

Post a reply

1 post • Page 1 of 1

Topics		Author	Replies	Views	Last post
Topics related to - "Mysql remove column from an existing table"
	Mysql: add column to table	debuser	1	2741	Fri Oct 08, 2010 8:38 am sonee4
	Mysql add Unique index to a table column	debuser	0	412	Fri Aug 06, 2010 5:01 pm debuser
	Mysql - Change position of a column after another column	admin	1	3491	Fri Oct 08, 2010 8:41 am sonee4
	Rename MySql table	debuser	1	461	Fri Oct 08, 2010 8:36 am sonee4
	MySql rename table	admin	2	327	Mon Nov 28, 2011 10:39 am Darwin

Who is online

Users browsing this forum: No registered users and 0 guests

You cannot post new topics in this forum
You cannot 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 ‹ Databases ‹ Mysql

Delete all board cookies | The team | All times are UTC + 2 hours [ DST ]