http://www.mysql.com/doc/R/E/RENAME_TABLE.html says:
As long as two databases are on the same disk you can also rename from one
database to another:
RENAME TABLE current_database.table_name TO other_database.table_name;
And as the user comments say, you can use ALTER TABLE with 3.22.
Copying c
Hi,
I am using mySQL 3.22.23 on a Linux platform. How can I copy or move Tables between
different Databases? Is there a simple command for that? We do not have the
mysqlhotcopy command; is it safe to download and use for our mySQL version, and can it
do what I want it to do? I cannot find anyt