a good mysql book?

[n8w]

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

Thanks
n8w

[wickning1]

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. :)

[n8w]

[!--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

[fenway]

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.