mysql drop column code example

Example 1: psql drop column

ALTER TABLE table_name 
DROP COLUMN column_name;

Example 2: how remove column in mysql

ALTER TABLE "table_name" DROP "column_name";

Example 3: mysql drop column

ALTER TABLE `claims_user_settings` DROP COLUMN `super_user`;

Example 4: add column in mysq

ALTER TABLE Table_name
ADD Email varchar(255);

Example 5: how delete a column in mysql

ALTER TABLE table_name
  DROP COLUMN column_name;