How can the name of a column be modified in MySQL?

2 years ago
William Carter
1 minute

To change the column name in MySQL, you can use the ALTER TABLE statement. Here is an example:

ALTER TABLE 表名 CHANGE 旧列名 新列名 列类型;

The specific steps are as follows:

  1. Use the ALTER TABLE statement to specify the table name you want to modify.
  2. Use the CHANGE keyword, followed by the old column name, new column name, and the data type of the new column, in that order.
  3. Executing the statement allows you to modify the column name.

For example, you can use the following statement to change the column “age” in the table “users” to “user_age”:

ALTER TABLE users CHANGE age user_age INT;

This will change the name of the column “age” to “user_age” and set the data type to INT.

Please note that performing this operation will modify the table structure and may affect other queries and operations related to this table. Before proceeding with this operation, please make sure to backup the data as a precaution.

bannerAds