Jump to content

Archived

This topic is now archived and is closed to further replies.

n8w

a good mysql book?

Recommended Posts

Hey can any one recommend a good mysql book? .. I want to learn about complex queries with all types of joins .. etc

Thanks
n8w

Share this post


Link to post
Share on other sites
I've never needed any more than the online documentation, it's pretty extensive.

I think the best way to internalize joins and subqueries is to practice a lot. You might try finding an old used textbook that has sets of problems to solve. Many of them will be Oracle based but it doesn't really matter all that much.

Or you could hang around here and try to help people. :)

Share this post


Link to post
Share on other sites
[!--quoteo(post=351171:date=Mar 2 2006, 09:43 PM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Mar 2 2006, 09:43 PM) [snapback]351171[/snapback][/div][div class=\'quotemain\'][!--quotec--]
I've never needed any more than the online documentation, it's pretty extensive.

I think the best way to internalize joins and subqueries is to practice a lot. You might try finding an old used textbook that has sets of problems to solve. Many of them will be Oracle based but it doesn't really matter all that much.

Or you could hang around here and try to help people. :)
[/quote]

good idea .. I need to participate in the forums and help more .. good idea

Share this post


Link to post
Share on other sites
Agreed -- good books are hard to come by, though the manual lacks extensive and/or useful examples for many cases, including joins. AFAIK, the "best" way to deal with joins is to use them as much as often, and leave subqueries for when subqueries are absolutely required, not just convienient. It takes practice, and takes longer, and it's definitely not the way that other DBs work (since they had sub-queries a long time ago), but it's worth the effort, IMHO. Good luck.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.