Hi All,
As per the below query, can we have simultaneous
connection with two DBS and refer both the DBs in the same query? Like
CREATE TABLE DB2.tblname LIKE DB1.tblname.
Regards,
Ravi K
-----Original Message-----
From: Dominik Klein [mailto:[EMAIL PROTECTED]
Sent: Friday, August 18, 2006 1:01 PM
To: mysql@lists.mysql.com
Subject: Re: Can a table be copied across the DBs?
> In the destination database the table doesn't exist. Please let me
know,
> if there is any way to do it.
CREATE TABLE DB2.tblname LIKE DB1.tblname;
INSERT INTO DB2.tblname SELECT * FROM DB1.tblname;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not the
intended recipient, you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately and destroy all copies of this message and
any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
www.wipro.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
