At 15:48 -0600 1/29/02, Demirchyan Oganes-AOD098 wrote:
>I need to export some data from one DB to another.
>Suppose I'm connected to DB1 and my trying to get stuff from there
>and insert into DB2. I'm using Insert Select statements. Once I'm
>connected to DB1, do I have to establish separate connection for DB2?
Not if they're both hosted by the same MySQL server.
And if they're not, you can't do this anyway. :-)
>An example Insert Select : Insert into db2.Pad_Analysis_Data
>(column names) Select * from db1.Pad_Analysis_Data;
>Motorola Life Science
>Pasadena, CA 91105