How to delete a column from a table in MySQL?

To delete a column from a table in MySQL, use the ALTER TABLE statement with the DROP COLUMN clause. Here’s the syntax:

ALTER TABLE table_name DROP COLUMN column_name;

For example, if you want to delete the column age from the users table:

ALTER TABLE users DROP COLUMN age;

This will remove the age column from the users table permanently. Make sure to back up any important data before making such changes, as this operation is irreversible.