Fastest Web Hosting

how i select data from multiple databases in mysql

0 votes
asked May 24, 2016 in Mysql by anonymous

Any Help??

2 Answers

0 votes
answered Aug 4, 2016 by raghman.gem (140 points)
SELECT table_a.c1 , table_a.c2, table_b.c1 , table_b.c2
FROM   table_a , table_b
WHERE  table_a.commonfield=table_b.commonfield
commented Aug 4, 2016 by Manoj Insan (1,600 points)
thanks for try raghman but we want fetch record from mutiple Database not just table..i hope you have cleared...
commented Aug 8, 2016 by sajad (580 points)
01. Create Multiple Connections for Databases.
02. Fetch your queries for different tables from Databases.
03. Store your queries result in multiple arrays,
04, use loops for array and showing up what you need.
0 votes
answered Aug 8, 2016 by sajad (580 points)

01. Create Multiple Connections for Databases.
02. Fetch your queries for different tables from Databases.
03. Store your queries result in multiple arrays,
04, use loops for array and showing up what you need.

Job Board

TechnicalSharp is a technical community of developers where they are sharing their knowledge and solutions and against it they are getting the score point which help them to make profile strong which is under eyes on MNC's
...