Drop Column in MySQL
Wednesday November 15, 2006
You can remove an entire column from a MySQL database by using the drop column command. This also removes all data from the column when it is removed.
©2008 About.com, a part of The New York Times Company.
All rights reserved.
Comments
give the example to drop column
It doens’t work…
I wrote:
ALTER TABLE T1 DROP DOB;
My tables is called T1 and my column is DOB for Date Of Birth.
I get:
ERROR: parser: parse error at or near “;”
I am using SSH Secure Shell 3.2.9, what is going on?