What are the methods to delete a field in mysql?

In MySQL, you can use the ALTER TABLE command to delete a field. Here are a few methods for deleting a field:

1. By using the DROP COLUMN keyword:

ALTER TABLE table_name
DROP COLUMN column_name;

1. 1. Use the MODIFY keyword and omit the fields to be deleted.

ALTER TABLE table_name
MODIFY column_name datatype;

This method will change the data type of the field to a new one and delete the original field.

1. Use the CHANGE keyword and omit the fields that need to be deleted.

ALTER TABLE table_name
CHANGE column_name new_column_name datatype;

This method will rename the field to a new field name and delete the original field.