Web Design Forums

greenmop · 28-06-2007, 15:37

Hi,

Does anyone knwo how to do the following easily.

I want to select fields from two tables but each table is on a different database on the same server.

I know how to do this in a stored procedure but mysql version is 3. Stored procedures where not available until version 5.

I am looking to do this in PHP but am not sure if this can be done as you can only connect to one database at a time.

cam · 28-06-2007, 17:07

unsure if it's supported in mysql3, but the query syntax is:

Code:

select database1name.tablename.fieldname, database2name.tablename.fieldname,
from database1name.tablename, database2name.tablename

Snowshiro · 28-06-2007, 22:02

How do you persuade the query to run across two concurrent open database connections?

28-06-2007, 15:37	#1 (permalink)
greenmop Registered User Join Date: Mar 2007 Posts: 30	multiple database select in mysql Hi, Does anyone knwo how to do the following easily. I want to select fields from two tables but each table is on a different database on the same server. I know how to do this in a stored procedure but mysql version is 3. Stored procedures where not available until version 5. I am looking to do this in PHP but am not sure if this can be done as you can only connect to one database at a time.

28-06-2007, 17:07	#2 (permalink)
cam vague™ Join Date: Mar 2004 Location: Glasgow Posts: 5,513	unsure if it's supported in mysql3, but the query syntax is: Code: select database1name.tablename.fieldname, database2name.tablename.fieldname, from database1name.tablename, database2name.tablename __________________ The Blog™ \| Twitter \| LinkedIn

LinkBacks (?) LinkBack to this Thread: http://www.designerstalk.com/forums/programming/27661-multiple-database-select-mysql.html
Posted By	For	Type	Date
Kaizenlog Â» Database 02/07/2007	This thread	Pingback	01-07-2007 18:31

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

28-06-2007, 22:02	#3 (permalink)
Snowshiro Will work for Marmite Join Date: May 2007 Location: Sapporo, Japan Posts: 573	How do you persuade the query to run across two concurrent open database connections?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)