mysql 重命名数据库表_mysql 数据库中如何对一个数据表进行重命名呢？

摘要：

下文讲述mysql数据库中对数据表重命名的方法分享，如下所示；

实现思路:

RENAME TABLE databaseName.oldTableName TO databaseName.newTableName;

例:

mysql> use maomao;

Database changed

mysql> show tables;

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

| Tables_in_maomao |

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

| maomao365.com |

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

1 rows in set (0.00 sec)

mysql> rename table maomao.`maomao365.com` to maomao.`maomao365.comB`;

Query OK, 0 rows affected (0.00 sec)

mysql> show tables;

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

| Tables_in_maomao |

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

| maomao365.comB |

| maomao_yarpp_related_cache |

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

1 rows in set (0.00 sec)

mysql> rename table `maomao365.comB` to maomao.`maomao365.comC`;

Query OK, 0 rows affected (0.00 sec)

mysql> show tables;

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

| Tables_in_maomao |

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

| maomao365.comC |

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

1 rows in set (0.00 sec)