How to delete a column from a table in MySQL?|Mysql table Drop column

Syntax:

ALTER TABLE table_name
DROP COLUMN column_name
Example:
ALTER TABLE table_Country DROP COLUMN Pincode;
Multiple tables:
ALTER TABLE table_Country
  DROP COLUMN Pincode,
  DROP COLUMN CountryName;

Post a Comment

0 Comments