Cross database query....Mysql databases

Question

Need to take each value from a column( say string) of a table (bucket) in Database1, then query for the same value under the same column name and table name in Database2.

is there an option to do that???

Need help...

can something like this be done?? pls help with syntax... DBI->connect( database1 ); 'SELECT string FROM bucket' foreach(value in string){ DBI->connect( database2); 'SELECT id,name,string FROM bucket where string = string of db1' — shreyasGowda
– shreyasGowda, Commented Feb 16, 2012 at 5:10

Robert · Accepted Answer · 2012-02-16 05:09:40Z

1

You can join the two databases with a statement similar to below. Of course putting in your database informaiton

SELECT database1.bucket.stringcolumn, database2.bucket.stringcolumn 
  FROM arbogast.node, mcguffin.node 
  WHERE database1.bucket.stringcolumn = Value 
   AND database1.bucket.stringcolumn = database2.bucket.stringcolumn;

Reference: http://www.dottedidesign.com/node/14

answered Feb 16, 2012 at 5:09

Robert

3,0843 gold badges25 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Robert Over a year ago

I don't see why not. You just need to put it in the proper perl syntax. Check out this link: tizag.com/perlT/perldbiquery.php

daxim Over a year ago

Please do not link to Tizag. As of early 2012, it is probably the worst tutorial in the world. - The official documentation is on dbi.perl.org

Collectives™ on Stack Overflow

Cross database query....Mysql databases

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related