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 mys
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
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 G
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
---
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.my
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 PR
