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]

Reply via email to