What's a good book for learning MySQL?

Question

I want to get a book to learn mysql. I know some things like basic selecting and updating but not very much. I don't really want a cookbook style book but a book that will give me an fundamental understanding of how SQL actually works so I understand the code I am writing instead of just copy+pasting it. I like orielly books so I was considering this one: clicky

Has anyone ready it? what book would you recommend? please recommend books that assume little to no SQL knowledge. Thanks!

Answer 1

http://dev.mysql.com/doc/refman/5.1/en/ - It's FREE! ;-)

For more of an introduction, try this: http://dev.mysql.com/tech-resources/articles/mysql_intro.html

Answer 2

I use this one and it has come in handy several times.

http://www.amazon.com/MySQL-Cookbook-Paul-DuBois/dp/059652708X/ref=sr_1_5?ie=UTF8&s=books&qid=1245182862&sr=8-5

Answer 3

Head First SQL uses MySQL in its examples, so I'd consider it. It also assumes you know nothing.

Answer 4

I use an old coy of "Beginning MySQL" by Sheldon and Moes

It serves me well. It is simple enough for a beginner, and has kept me happy in my intemediate stage for about a year now.

Answer 5

http://www.w3schools.com/sql/default.asp