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 [email protected: d...@in-telegence.net]=0D
Sent: Friday, August 18, 2006 1:01 PM
To: [email protected: m...@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;
--=0D
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dravi.karatagi@wipro.com
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.=0D
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.
=0D
www.wipro.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: [unsubscribe url hidden]