3月 182013
 

テーブル名の変更はRENAMEを使用します。

mysql> ALTER TABLE  RENAME ;
mysql> show tables;
+---------------+
| Tables_in_slt |
+---------------+
| member        |
| slt           |
+---------------+
2 rows in set (0.00 sec)

mysql> ALTER TABLE member RENAME user;
Query OK, 0 rows affected (0.00 sec)

mysql> show tables;
+---------------+
| Tables_in_slt |
+---------------+
| slt           |
| user          |
+---------------+
2 rows in set (0.00 sec)

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>