Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides
Register
FAQ
It is currently Mon Mar 08, 2021 9:27 am

ROOT ‹ Website Development and Databases ‹ Mysql ‹ Mysql remove column from an existing table

Post a reply :: Mysql remove column from an existing table
Username:
Subject:
Message body:
Enter your message here, it may contain no more than 60000 characters. 

Smilies
:D :) ;) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :!: :?: :idea: :arrow: :| :mrgreen: :geek: :ugeek:
Font size:
 
Font colour
Options:
BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON
Disable BBCode
Disable smilies
Do not automatically parse URLs
Confirmation code
Confirmation code:
In an effort to prevent automatic submissions, we require that you enter both of the words displayed into the text field underneath.
     

Topic review - Mysql remove column from an existing table
Author Message
debuser
Post subject: Mysql remove column from an existing table  |  Post Posted: Fri Aug 06, 2010 10:06 am
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.
Jump to:  
cronNews News Site map Site map SitemapIndex SitemapIndex RSS Feed RSS Feed Channel list Channel list


ROOT ‹ Website Development and Databases ‹ Mysql
Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]



phpBB SEO