Re: how to create insert from select
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
|