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
-
From: <[EMAIL PROTECTED]>
To:
Sent: Friday, August 18, 2006 9:29 AM
Subject: Can a table be copied across the DBs?
Hi All,
I want to copy a table (along with its contents) from one
database to another database.
In the destination database the table doesn't exist. Plea
ein" <[EMAIL PROTECTED]>
To:
Sent: Friday, August 18, 2006 1:01 PM
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 D
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:h
[EMAIL PROTECTED] wrote:
Hi All,
I want to copy a table (along with its contents) from one
database to another database.
In the destination database the table doesn't exist. Please let me know,
if there is any way to do it.
mysqldump -u -p original_databasename | mysql -u
-p ne
Hi All,
I want to copy a table (along with its contents) from one
database to another database.
In the destination database the table doesn't exist. Please let me know,
if there is any way to do it.
Regards,
Ravi K
The information contained in this electronic message and an
