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

FAQ

It is currently Sun Dec 10, 2023 5:36 am

ROOT ‹ Website Development and 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

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 10:06 am

Joined: Thu Aug 06, 2009 2:48 am
Posts: 105

Mysql remove column from an existing table

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.

			Tweet
Follow @IvordeCom

You might also be interested in:
Mysql: add column to table. Mysql add Unique index to a table column. Mysql - Change position of a column after another column. Mysql change column's default value. Rename MySql table. MySql rename table. How to calculate mysql time difference between unix timestamp column and now() format. Mysql drop (remove) unique key. 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).

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	4266	Fri Oct 08, 2010 1:38 am sonee4
	Mysql add Unique index to a table column	debuser	0	3306	Fri Aug 06, 2010 10:01 am debuser
	Mysql - Change position of a column after another column	admin	1	4422	Fri Oct 08, 2010 1:41 am sonee4
	Mysql change column's default value	debuser	0	2794	Thu Aug 12, 2010 3:43 am debuser
	Rename MySql table	debuser	1	2373	Fri Oct 08, 2010 1:36 am sonee4
	MySql rename table	admin	2	2857	Mon Nov 28, 2011 3:39 am Darwin
	How to calculate mysql time difference between unix timestamp column and now() format	mandrei99	0	9670	Fri May 31, 2013 4:10 am mandrei99
	Mysql drop (remove) unique key	mandrei99	0	2723	Wed Jan 14, 2015 7:53 pm mandrei99
	Mysql> select records that have date/datetime column equal to today's date	admin	0	3990	Tue Nov 22, 2011 9:40 am admin
	MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)	debuser	0	3220	Mon Feb 22, 2010 1:43 pm debuser

Who is online

Users browsing this forum: No registered users and 0 guests

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 ]