Re: copy the result content from one db to another
This works just like doing it from table to table, just specify hte db insert into dbname.tablename select * from db1.tablename where id < 3; HTH Jeff Dr M Karthikeyan <[EMAIL PROTECTED]To: [EMAIL PROTECTED] c.edu> cc: Subject: copy the result content from one db to another 11/17/2003 10:51 AM I would like to copy the contents of result set by single command e.g., select * from db1 where id < 3; result 1 result 2 now how to write this results into another db without writing to a text file (outtext)... when both source and destination has the same structure thanks m.karthikeyan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: copy the result content from one db to another
insert into ... select ... -Original Message- From: Dr M Karthikeyan [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 9:51 AM To: [EMAIL PROTECTED] Subject: copy the result content from one db to another I would like to copy the contents of result set by single command e.g., select * from db1 where id < 3; result 1 result 2 now how to write this results into another db without writing to a text file (outtext)... when both source and destination has the same structure thanks m.karthikeyan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]