[mysql]테이블 이름변경(rename)

형식) rename table 현재테이블명 to 변경할 테이블명 :

ex)

mysql> show tables;
+--------------------+
| Tables_in_found_db |
+--------------------+
| mo_member          |
+--------------------+
1 row in set (0.00 sec)

mysql> rename table mo_member to f_member;
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+--------------------+
| Tables_in_found_db |
+--------------------+
| f_member           |
+--------------------+
1 row in set (0.00 sec)