mysqlmodify_MySQL - change 和 modify 的区别

表描述:

mysql> desc test;

+-------+----------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+----------+------+-----+---------+-------+

| id | int(10) | YES | | NULL | |

| name | char(10) | YES | | NULL | |

+-------+----------+------+-----+---------+-------+

2 rows in set (0.01 sec)

MySQL 中 change 和 modify 区别

更改列名 change: alter table 表名 change 旧列名 新列名 类型

mysql> alter table test change name name_new int(10);

Query OK, 0 rows affected (0.02 sec)

Records: 0 Duplicates: 0 Warnings: 0

mysql> desc test;

+----------+---------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+----------+---------+------+--