How does MySQL modify table fields with SQL statements?

1. Today's tasks create a table structure with SQL statements according to the following table

2. When creating the table structure, accidentally put the last field in the full-capitalization status, looking really uncoordinated, so prepare to modify this field

3. There are many ways to modify

1. I use the MySQL database, you can directly select the table, right-click Design table, directly modify the save on OK

2. or drop table table to delete, recreate table table to create new tables

2. But what I need is a SQL statement to modify, the input SQL statement to run the modification succeeded

　　

Note: Some people see that the number of rows affected is 0, it is necessary to ask whether there is any modification of success, the answer is yes. The table structure is modified here, not the table data, so the number of rows affected is displayed as 0.

Using a different database may manipulate the syntax of the database slightly differently, and you need to be aware of it.

How does MySQL modify table fields with SQL statements?