List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:February 13 2007 1:05pm
Subject:Re: Query Two Databases
View as plain text  
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


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


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




>To: mysql@stripped
>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 different databases.  Is it possible to retrieve data from the
> > different tables in one query ?
>
>(SELECT * FROM db1.table) UNION (SELECT * FROM db2.table)
>
>If db2 on a other mysql server, it is possible to use the
>federated storage engine of MySQL.
>
>- --
>Database and System Administration
>
>studiVZ | Saarbrueckerstr. 38 | 10405 Berlin | phone +49-(0)30-405042715
>www.studiVZ.net  |  fax +49-(0)30-28093887   |  cell  +49-(0)175-9331740
>www.estudiLN.es  |  www.studentIX.pl  | www.studiQG.fr |  www.studiLN.it
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.4.6 (MingW32)
>Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
>iD8DBQFFuI4cYT5ehyp2X5ERAh/AAKCEDPXhlegrCu08jG0K3Eh/ZxIfgwCeIbZz
>hJRxd5b07AxIlFP8/RBKQx0=
>=G/4h
>-----END PGP SIGNATURE-----
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    
>http://lists.mysql.com/mysql?unsub=1
>

_________________________________________________________________
http://ideas.live.com

Thread
Query Two DatabasesNeil Tompkins25 Jan
  • Re: Query Two DatabasesMartijn Tonies25 Jan
    • Re: Query Two DatabasesNeil Tompkins25 Jan
      • Re: Query Two DatabasesDuncan Hill25 Jan
      • Re: Query Two DatabasesMartijn Tonies25 Jan
  • Re: Query Two DatabasesNils J√ľnemann25 Jan
    • Re: Query Two DatabasesNeil Tompkins13 Feb
Re: Query Two DatabasesNeil Tompkins13 Feb
  • Re: Query Two DatabasesJohn Meyer13 Feb
  • Re: Query Two DatabasesHenrique Dallazuanna13 Feb