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.,

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