请高手解决个问题。。

Question

如何用SQL语句修改表的列名？？？

Answer 1

mysql> desc t1;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| date          | date         | NO   |     | NULL    |       |
| name          | varchar(255) | NO   |     | NULL    |       |
| score         | int(11)      | NO   |     | NULL    |       |
| interval_date | int(11)      | NO   |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
4 rows in set (0.13 sec)-- 修改表t1的name列名为pname
mysql> alter table t1 change name pname varchar(255);
Query OK, 12 rows affected (0.13 sec)
Records: 12  Duplicates: 0  Warnings: 0mysql> desc t1;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| date          | date         | NO   |     | NULL    |       |
| pname         | varchar(255) | YES  |     | NULL    |       |
| score         | int(11)      | NO   |     | NULL    |       |
| interval_date | int(11)      | NO   |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
4 rows in set (0.02 sec)mysql>手册中有语法说明。
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html

Answer 2

当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html