Hi, if they have the same format (fields, etc): INSERT INTO db1.table1 SELECT (fields) FROM db2.table2 WHERE ...;
Ciao, Ronald > -----Original Message----- > From: Charitha [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 25, 2002 10:23 > To: [EMAIL PROTECTED] > Subject: Copying records b/w diff databases. > > > > In mysql i have to copy selected records from one database table to > another database table. > How to do that? > > thanx in advance. > -- > Regards, > Charitha > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
