Hi Shawn,
>
> I have never tried any of the NATURAL joins so your results were very
> interesting to me. The order in which the rows were joined provides you
> with some insight about how the engine actually performs the joins (which
> table is in the outer loop and which is in the inner loop). *w
news <[EMAIL PROTECTED]> wrote on 12/19/2005 11:37:41 AM:
> Hi Shawn,
>
> > That means that MySQL supports the means to determine what rows are in
> > each area of our diagram based on the direction of the join (INNER,
LEFT,
> > or RIGHT), the conditions declared in the ON clause, and any filter
news <[EMAIL PROTECTED]> wrote on 12/19/2005 11:28:36 AM:
> Hi Shawn,
>
>
> It's beginning to build a lot of information in a single message. So I
cut
> it in parts.
>
>
> > In order to compute the intermediate table, each row on the left side
of
> > the predicate is evaluated in combination
> >
> > */-\ /-\
> > * / \ / \
> > * / X \
> > * / / \ \
> > */ / \ \
> > *|A| B | C |
> > *\ \ / /
> >
> > */-\ /-\
> > * / \ / \
> > * / X \
> > * / / \ \
> > */ / \ \
> > *|A| B | C |
> > *\ \ / /
> > *
Hi Shawn,
It's beginning to build a lot of information in a single message. So I cut
it in parts.
> In order to compute the intermediate table, each row on the left side of
> the predicate is evaluated in combination with each and every row from the
> right side of the predicate. If the ON cla
Hi Bill, (answers intermixed)
"Bill" <[EMAIL PROTECTED]> wrote on 12/18/2005 07:33:52 PM:
> Hi Shawn,
>
>
>
> */-\ /-\
> * / \ / \
> * / X \
> * / / \ \
> */ /
It's not your fault, the documentation is very light on the topic of
JOINing ( I have made a feature request to improve this). Joining two
tables works like this
Draw two circles on a piece of paper, Make sure they overlap to some
degree. Put an A in the left circle not part of the overlap
Hi
Works #1
I tought GROUP BY was a grouping algo not a summarizing instruction.
I have problems understanding the meaning of INNER, LEFT etc.
Does LEFT mean that the joined table will be placed before the actual table
? meaning that calculations will be made against the joined table first ?
Co
Responses intermixed. See below ...
news <[EMAIL PROTECTED]> wrote on 12/17/2005 03:16:48 PM:
> Hi
>
> I have the following tables:
> CREATE TABLE `livres`(
> `id` int(10) unsigned NOT NULL auto_increment,
> `isbn` varchar(12) NOT NULL default '',
> 'titre' varchar(80) NOT NULL default '',
Hi
I have the following tables:
CREATE TABLE `livres`(
`id` int(10) unsigned NOT NULL auto_increment,
`isbn` varchar(12) NOT NULL default '',
'titre' varchar(80) NOT NULL default '',
`auteur` int(10) unsigned NOT NULL default '0',
`categorie` varchar(60) NOT NULL default '',
PRIMARY KEY (
11 matches
Mail list logo
