Jannie,
- Original Message -
From: Jannie Qu [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, January 21, 2003 1:30 AM
Subject: Is rename table to another database safe for INNODB tables
sql, query,
Hi, all,
As you may knew, mysql will implement rename database
sql, query,
Hi, all,
As you may knew, mysql will implement rename database in version 4.1
Right now, I need to rename a database, what I plan to do is rename each
table (INNODB type, version 3.23.53 on MAC OS) to another new database.
RENAME TABLE current_db.tbl_name TO new_db.tbl_name;
Do