Hi,
It is
Rename table name to database.tablename.
db-1
db-2
rename db1.tablename to db2.tablename.
This might help you out.
murthy gandikota wrote:
How can I copy tables from one database to another on the same host?
Thanks for your help
Murthy
__
Perhaps the easiest way is with CREATE TABLE... SELECT. For example,
if I have a database called "NYCNH" (by coincidence, I do!) which
contains a table called "checks" and I want to copy that table to a
database called "TEST" I could do this:
mysql> create table test.checks select * from n