Hello Kevin,
Thursday, July 03, 2003, 12:28:38 AM, you wrote:
For example you can do this: /with Perl/
Make connection to first database , then fill data from table source in array, then
make
connection to another database and fill data from array to another
table.
K Hello,
K I have two
Hello,
I have two mysql databases running on different hosts - the database are
similiar in structure. I would like to copy specific tables from one db to
another db on a scheduled basis.
Is there a command to replicate a table from one db to another on a
different host?
TIA
-roy
--
MySQL
On Wed, Jul 02, 2003 at 02:28:38PM -0700, Kevin wrote:
Hello,
I have two mysql databases running on different hosts - the database are
similiar in structure. I would like to copy specific tables from one db to
another db on a scheduled basis.
Is there a command to replicate a table from
Can mysql copy from table1 to table2?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
Yes,
CREATE TABLE tbl SELECT * FROM tbl;
Vivian Wang wrote:
Can mysql copy from table1 to table2?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Wednesday, 17. July 2002 18:07, Vivian Wang wrote:
Can mysql copy from table1 to table2?
Yes, if table t2 doesn't exist you have to create table2 first.
Then you can use INSERT .. SELECT STAMENT.
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Regards
Georg
mysql,query