Greetings and thanks in advance.

I need to insert data into a table from a select statement from a
different database on another physical machine. I was just planning on
using copy and paste to do it. My goal is to create the insert syntax
from a select statement but not insert on the intial machine where I
executed the select statement. Just create the insert statement and
I'll just happily copy and paste to the other machine.


usaims

usaims wrote:
> Greetings and thanks in advance.
>
> I need to insert data into a table from a select statement from a
> different database on another physical machine. I was just planning on
> using copy and paste to do it. My goal is to create the insert syntax
> from a select statement but not insert on the intial machine where I
> executed the select statement. Just create the insert statement and
> I'll just happily copy and paste to the other machine.
>
>
> usaims

Use mysqldump or if you have phpmyadmin, use the export function. It creates
INSERT statements for you