esigns.com]
> Sent: April 26, 2010 10:29 PM
> To: mysql@lists.mysql.com
> Subject: Re: Join syntax problem
>
> Thanks for the replies. It was my understanding that whitespace is
> ignored,
> and I did not think that not having space, in particular with "." wou
Thanks for the replies. It was my understanding that whitespace is ignored,
and I did not think that not having space, in particular with "." would
result in an error message.
Gary
""Gary"" wrote in message
news:20100426233621.10789.qm...@lists.mysql.com...
I cant seem to get this working.
I am reading this on a tiny screen but it looks like you need
whitespace before the where.
On 4/26/10, Gary wrote:
> I cant seem to get this working.
>
> $query="SELECT im.image_id, im.caption, im.where_taken, im.description,
> im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.ameri
On 4/26/10 7:36 PM, "Gary" wrote:
> I cant seem to get this working.
>
> $query="SELECT im.image_id, im.caption, im.where_taken, im.description,
> im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.american,
> kw.scenic, kw.birds, kw.africa, kw.eagles, kw.hunter" .
> "FROM *images A
Please reply to the list, rather than to me, personally. Keeping the thread
on the list improves your odds of geting a solution, and allows others with
similar questions to see the answers.
Marco wrote:
Michael Stassen wrote:
What do you mean, it doesn't work?
Michael
Marco wrote:
The query
>
What do you mean, it doesn't work?
Michael
Marco wrote:
The query
> select * from a join b on a.x = b.y;
works on mySQL 3.23.56 but doesn't work on mySQL 3.23.58.
I had to change it in
> select * from a,b where a.x = b.y;
Is it a well-known behavior or is it a bit strange?
Thanks,
Marco
--
MySQL
27 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Join syntax diff 3.23 to 4.x?
>
>
> Try changing "JOIN list_states " to "INNER JOIN list_states "
>
> Looks like the earlier version didn't like your (synonymous) wording.
>
> >
Doh! You are so right. Thanks for the help. Got so used to not needing the
INNER word that I forgot all about it.
-Original Message-
From: Kevin Fries [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 1:27 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Join syntax diff
Try changing "JOIN list_states " to "INNER JOIN list_states "
Looks like the earlier version didn't like your (synonymous) wording.
> -Original Message-
> From: Jack Dare [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 14, 2003 8:35 AM
> To: [EMAIL PROTECTED]
> Subject: Join syntax di
.1443|
||
--
|__|__|
|| ||
ooO Ooo
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 12:58 PM
To: Werner Stuerenburg
Cc: [EMAIL PROTECTED]
Subject: Re: Join syntax
I have two databases (db1 e db2) on different hosts (host1 e host
This topic really interested me.
Can an expert of the list explain a good approach handle distributed system
with distributed databases?
thanks
siomara
>From: <[EMAIL PROTECTED]>
>To: Werner Stuerenburg <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Join s
RAMOS RODNEYR/Embratel@Embratel
cc: [EMAIL PROTECTED]
As it seems, it is not possible. You would have to have a
connection which talks to two databases at once, which may not be
possible at all, at least create numerous problems.
But I think it should be possible to create a temporary table in
db 2 and copy the table from db1 into it, then do a join
On Mon, Jul 09, 2001 at 09:29:00PM -0300, Rodney A. Ramos wrote:
>
> Is it possible to join two tables from different databases that are
> located on different hosts?
Nope.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454C
> Is it possible to join two columns from different databases
Yes.
> located on differents hosts?
No. Why do you want to do this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
I don't know what you are trying to accomplish but here is the way I would
build a table using ALL the data field from two tables. first is a
straight join which will only build the records that have an equal in both
tables.
insert into tbla select distinct tblb.*, tblc.* from tblb, tblc where
16 matches
Mail list logo
