Drop Column in MySQL

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?

You just have to use

alter table t1 drop column dob

How to delete more than one field from table

how to drop a column which is a foreign key.