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/ |