极客教程MySQL 如何从MySQL表中更改现有列的名称？
我们可以使用CHANGE语句和ALTER语句一起来更改MySQL表中特定现有列的名称。其语法如下−
阅读更多：MySQL 教程
语法
ALTER TABLE table_name CHANGE old_column_name new_column_name datatype;
在这里，
- table_name 是要从中删除列的表名。
- Old_column_name 是要更改的列的名称。
- new_column_name 是要给旧列的名称。
例子
在此示例中，我们正在将 ‘id’ 的列名更改为 ‘studentid’ ，从表格 ‘student_info’ 如下 −
mysql> Select * from Student_info;
+------+---------+------------+------------+
| id | Name | Address | Subject |
+------+---------+------------+------------+
| 101 | YashPal | Amritsar | History |
| 105 | Gaurav | Chandigarh | Literature |
| 130 | Ram | Jhansi | Computers |
| 132 | Shyam | Chandigarh | Economics |
| 133 | Mohan | Delhi | Computers |
+------+---------+------------+------------+
5 rows in set (0.02 sec)
mysql> ALTER TABLE Student_info CHANGE id studentid int;
Query OK, 0 rows affected (0.22 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> Select * from Student_info;
+-----------+---------+------------+------------+
| studentid | Name | Address | Subject |
+-----------+---------+------------+------------+
| 101 | YashPal | Amritsar | History |
| 105 | Gaurav | Chandigarh | Literature |
| 130 | Ram | Jhansi | Computers |
| 132 | Shyam | Chandigarh | Economics |
| 133 | Mohan | Delhi | Computers |
+-----------+---------+------------+------------+
5 rows in set (0.00 sec)
上面的结果集显示列‘id’的名称已更改为‘Studentid’。