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
Hi,
Yes it can be done.
Hi,
Create table can be done across the database but please let me know what
version are us using (MYSQL).
mysql> create table test.tww like broadbandnew.cds ;
Query OK, 0 rows affected (0.06 sec)
Thanks & Regards
Dilipkumar
- Original Message -
From: <[EM
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
