Jump to content


Photo

a good mysql book?


  • Please log in to reply
3 replies to this topic

#1 n8w

n8w
  • Members
  • PipPipPip
  • Advanced Member
  • 123 posts

Posted 03 March 2006 - 12:00 AM

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

Thanks
n8w

#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 03 March 2006 - 12:43 AM

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

#3 n8w

n8w
  • Members
  • PipPipPip
  • Advanced Member
  • 123 posts

Posted 03 March 2006 - 12:49 AM

[!--quoteo(post=351171:date=Mar 2 2006, 09:43 PM:name=wickning1)--][div class=\'quotetop\']QUOTE(wickning1 @ Mar 2 2006, 09:43 PM) View Post[/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


#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 March 2006 - 01:31 AM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users