How can you delete a specific field in MySQL?

In MySQL, to remove a specific column, you can use the DROP COLUMN clause of the ALTER TABLE statement.

The grammar is as follows:

ALTER TABLE 表名
DROP COLUMN 列名;

Suppose there is a table called students with three columns: id, name, and age. If we need to remove the age column, we can use the following statement:

ALTER TABLE students
DROP COLUMN age;