How can I copy tables from one database to another on the same host?
Thanks for your help
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
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
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