copy the result content from one db to another

2003-11-17 Thread Dr M Karthikeyan 
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]

RE: copy the result content from one db to another

2003-11-17 Thread Victor Pendleton 
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]

Re: copy the result content from one db to another

2003-11-17 Thread jeffrey_n_Dyke 

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]