Drop Column – MySQL Command
Definition: Drop column is used to remove a column from a given table. This also removes all data from the column. It is written as alter table [table name] drop column [column name];
Also Known As: MySQL Drop Column, Remove Column, Delete Column
Examples:
alter table icecream drop column flavor;
This removes the column “flavor” from the table called “icecream”.
Latest posts by Editor (see all)
- How to Show files by size, biggest last- Linux Commands - January 21, 2011
- How to test for unreadable blocks on disk- Linux Commands - January 21, 2011
- How to Do a read speed test on disk sda – Linux Commands - January 21, 2011