For Programmers: Free Programming Magazines  


Home > Archive > PHP Programming > May 2004 > Joining tables in MySQL









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Joining tables in MySQL
Chung Leong

2004-05-23, 6:30 pm

Is there any speed different between

SELECT a.cow_id, a.name
FROM cow a INNER JOIN farm b ON a.farm_id = b.farm_id
WHERE [conditions]

and

SELECT a.cow_id, a.name
FROM cow a, farm b
WHERE a.farm_id = b.farm_id AND [conditions]

in MySQL?


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2010 codecomments.com