Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides
https://forum.ivorde.com/

Mysql remove column from an existing table
https://forum.ivorde.com/mysql-remove-column-from-an-existing-table-t117.html
Page 1 of 1

Author:  debuser [ Fri Aug 06, 2010 10:06 am ]
Post subject:  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.

Page 1 of 1 All times are UTC - 5 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/