mysql怎么用sql语句修改某个列的数据类型？

[dingding_hi]

标准的SQL语句修改某个列的类型是这样的：alter table [表的名称] alter column [列的名称] [数据类型]

但是当我用这种语法在MySQL中修改某个列的类型时，MySQL会提示语法错误。

不知道在MySQL中怎么用sql语句来修改列的类型呢？

[WWWWA]

ALTER TABLE b MODIFY gg VARCHAR(10)

[vipper23]

ALTER TABLE t1 CHANGE b b BIGINT NOT NULL;

[vipper23]

ALTER TABLE t1 MODIFY b BIGINT NOT NULL;

[ACMAIN_CHM]

alter table b change up up varchar(10);

mysql> desc b;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| id          | int(4)      | NO   | PRI | NULL    | auto_increment |
| foreignName | varchar(45) | YES  |     | NULL    |                |
| up          | float       | YES  |     | NULL    |                |
| down        | float       | YES  |     | NULL    |                |
+-------------+-------------+------+-----+---------+----------------+
4 rows in set (0.02 sec)

mysql> alter table b change up up varchar(10);
Query OK, 4 rows affected (0.19 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> desc b;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| id          | int(4)      | NO   | PRI | NULL    | auto_increment |
| foreignName | varchar(45) | YES  |     | NULL    |                |
| up          | varchar(10) | YES  |     | NULL    |                |
| down        | float       | YES  |     | NULL    |                |
+-------------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql>

[ACMAIN_CHM]

具体语法，你可以参考alter table
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html