At the moment we are using mysql 3.23.58. It would appear I can't use UNION
in this version ?
Do I have any other options, without upgrading the database server version ?
Regards,
Neil
From: Nils Jünemann [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Query Two Databases
Date
. It would appear I can't use UNION
in this version ?
Do I have any other options, without upgrading the database server version ?
Regards,
Neil
From: Nils Jünemann [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Query Two Databases
Date: Thu, 25 Jan 2007 12:01:48 +0100
-BEGIN PGP
Neil Tompkins wrote:
Following on from the email below, if I run the query
SELECT * FROM database1.table, database2.table
I get the data back, but all the data is in the same row.
How can I seperate the records ?
Regards
Neil
Barring an upgrade, it seems your best bet would be to
?
Regards,
Neil
From: Nils Jünemann [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Query Two Databases
Date: Thu, 25 Jan 2007 12:01:48 +0100
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Neil Tompkins schrieb:
Not sure if this is possible or not. But I've two identical tables in
two
Not sure if this is possible or not. But I've two identical tables in two
different databases. Is it possible to retrieve data from the different
tables in one query ?
Yes, by using this notation:
select *
from mydatabase.mytable
Martijn Tonies
Database Workbench - development tool for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Neil Tompkins schrieb:
Not sure if this is possible or not. But I've two identical tables in
two different databases. Is it possible to retrieve data from the
different tables in one query ?
(SELECT * FROM db1.table) UNION (SELECT * FROM
The databases are on the same server, however the login details for each
database are different.
From: Martijn Tonies [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Query Two Databases
Date: Thu, 25 Jan 2007 11:56:37 +0100
Not sure if this is possible or not. But I've two
On Thursday 25 January 2007 11:08, Neil Tompkins wrote:
The databases are on the same server, however the login details for each
database are different.
A query executes with the credentials of the authentication used to set up the
connection. If you want to query two tables simultaneously
The databases are on the same server, however the login details for each
database are different.
Hmm, I guess that the currently connected user needs to have access
to both databases, how else would it get the data?
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
I've had success using the fully qualified db, table and column name in
a single query like yours below. Have you tried sending strSQLCombo
through either strConnProd or strConnSales already?
K. Mazur Worden
-Original Message-
From: brent [mailto:[EMAIL PROTECTED]
Sent: Monday,
Mazur Worden, Kathy wrote:
I've had success using the fully qualified db, table and column name in
a single query like yours below. Have you tried sending strSQLCombo
through either strConnProd or strConnSales already?
K. Mazur Worden
Kathy,
Just tried referencing one and got the Item
Subject: Re: Query two databases
Mazur Worden, Kathy wrote:
I've had success using the fully qualified db, table and
column name in
a single query like yours below. Have you tried sending
strSQLCombo
through either strConnProd
Mazur Worden, Kathy wrote:
which column(s) isn't found? Would it happen to be any of the columns
you're using a function on? I ask because aliasing those might help.
I can confirm that passing the full db name will work with ASP through a
recordset. I've set them up like this:
Set
13 matches
Mail list logo