Best MySQL Learning Book?

[JeffWalden]

I've used MySQL for some time now and worked with relational database design enough to know that I don't know enough. Any recommendations for a good learning tool/book? I don't see one from SitePoint... ::gasp!::

[guelphdad]

For a more advanced book, check out SQL Hacks by Andrew Cummings, while not mysql specifically, the authors go to lengths to provide necessary tweaks to the code. They examine SQL Server, Oracle, MySQL among others and make sure the code runs on at least two of the platforms. Many of them run on MySQL via examples.

[unformatik]

I've used MySQL for some time now and worked with relational database design enough to know that I don't know enough. Any recommendations for a good learning tool/book? I don't see one from SitePoint... ::gasp!::

I think that :

1/Simply SQL by Sitepoint
2/SQL Essential Training by Lynda.com

are the best couple!

[BrandonK]

I'm a big fan of http://www.amazon.com/Practical-Data.../dp/1904151205 And you can get it VERRRY cheap now

[r937]

And you can get it VERRRY cheap now

[old_iron]

SimplySQL !!!

It teaches you so much in relatively few pages!

[jonpugh114]

I got a good introduction to MySQL from Larry Ullman's "PHP and MySQL For Dynamic Websites", but I'd like to find a book to take me to the next level.

Has anyone read "MySQL Cookbook" (2006 edition) by Paul Dubois, and is it any good? Otherwise, has anyone got any other suggestions?

Cheers,

Jon

[randalusa]

I think that :

1/Simply SQL by Sitepoint
2/SQL Essential Training by Lynda.com

are the best couple!

Still trying to get this stuff down myself, I would fear getting an "SQL" book rather than a MySQL text because it is already difficult enough stuffing the syntax into my gray matter.

Any books for slightly dumb people that focus on just MySQL, and cover both the basics and then maybe a teensy bit of optimization and stuff like that?

I noticed yesterday that my own Php/MySql books only offer the essentials (update, delete, insert) where database instruction is presented.

Wow, this forum has a million smilies to choose from.


Randal

[r937]

Still trying to get this stuff down myself, I would fear getting an "SQL" book rather than a MySQL text because it is already difficult enough stuffing the syntax into my gray matter.

i think it would be better learning the "real" syntax first, which you can then apply to mysql along with learning the syntax quirks that are proprietary to mysql

[SpacePhoenix]

Build Your Own Database Driven Website Using PHP & MySQL(new edition due out at the end of the month)

[felgall]

i think it would be better learning the "real" syntax first, which you can then apply to mysql along with learning the syntax quirks that are proprietary to mysql

I agree Rudy. Of all the SQL books I have seen yours looks to be the best book for beginners.

[randalusa]

i think it would be better learning the "real" syntax first, which you can then apply to mysql along with learning the syntax quirks that are proprietary to mysql

I agree Rudy. Of all the SQL books I have seen yours looks to be the best book for beginners.

May as well give 'er a look. Could be the presentation will be just right. Thanks.

Build Your Own Database Driven Website Using PHP & MySQL(new edition due out at the end of the month)

I will have a peek at this one too.

Great to have a couple places to begin at least.


Randal