Re: copy the result content from one db to another

[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]