mysql primary key id debate

Jonathan Ellis jonathan at carnageblender.com
Thu Dec 29 16:59:55 MST 2005


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




More information about the PLUG mailing list