MySQL Drop column

MySQL Drop column

Drop column from MySQL table using alter table syntax.

MySQL Drop column syntax

ALTER TABLE table_name DROP COLUMN column_name;

Drop column example

ALTER TABLE `books` DROP COLUMN `stock`;

Output

table `books` altered.