How to modify mysql column name

How to modify the mysql column name: First select a data table to be operated, and right-click to select the design table; then modify the field name directly in it, or modify the column name through the alter table statement. Can.

Related free learning recommendations:mysql database(Video)

##Modify Mysql column name method:

1. First select a data table to be operated on, as shown in the figure below

2. Then we You can directly right-click to select the design table, as shown in the figure below

3, and then modify the field name directly in it

4. You can also create a new query, as shown in the figure below.

5. Then modify the column name through the alter table statement as shown in the figure below. , as shown in the figure below

6. After executing the statement, we see that the list has been modified, as shown in the figure below

The above is the detailed content of How to modify mysql column name. For more information, please follow other related articles on the PHP Chinese website!