tabase 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 SIGNED MESSAGE-
>Hash: SHA1
>
>Neil Tompkins schrieb:
> >
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 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
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 Dat
> 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!
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.
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To:
Subject: Re: Query Two Databases
Date: Thu, 25 Jan 2007 11:56:37 +0100
> Not sure if this is possible or not. But I'
-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 db2.t
> 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 fo
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 objConn
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
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.
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 cann
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, A
13 matches
Mail list logo
