mysql primary key id debate

Stuart Jansen sjansen at buscaluz.org
Thu Dec 29 17:38:17 MST 2005


On Thu, 2005-12-29 at 15:59 -0800, Jonathan Ellis wrote:
> On Thu, 29 Dec 2005 16:48:39 -0700, "Stuart Jansen"
> <sjansen at buscaluz.org> said:
> > Roberto, I don't see how it helps in queries.
> > SELECT foo, bar FROM foo_table AS foo, bar_table AS bar
> > WHERE foo.id = bar.id;
> 
> SELECT foo, bar from foo_table NATURAL JOIN bar_table
> 
> -J
> -- 
> C++ is history repeated as tragedy. Java is history repeated
> as farce.  --Scott McKay

I bow to your superior sig.

-- 
Stuart Jansen              e-mail/jabber: sjansen at buscaluz.org
                           google talk:   stuart.jansen at gmail.com
:0                         # copy & paste for your convenience
* ^From:.*sjansen@
/dev/null                  # /ignore sjansen!*@*
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://plug.org/pipermail/plug/attachments/20051229/7ed15a20/attachment.bin 


More information about the PLUG mailing list