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