At 15:48 -0600 1/29/02, Demirchyan Oganes-AOD098 wrote: >Hello everyone, > >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; > >Thanks, > >Oganes Demirchyan >Motorola Life Science >757 S.Raymond >Pasadena, CA 91105 >Tel: 626-584-5900 >email: [EMAIL PROTECTED] --------------------------------------------------------------------- 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
