What is the best book for SQL, particularly MySQL?
High Performance MySQL 2nd Ed. is the best MySQL specific book out there. Plenty of advanced information on database design and optimization, analysis and profiling, scaling and more.
For general SQL, have a look at Learning SQL by Oreilly, or just about any SQL tutorial on the web.
For learning MySQL the database, a great book is MySQL Press's MySQL Tutorial.
A good book for learning Structured Query Language is A Guide to SQL. It's a textbook and working through the end-of-chapter material is important to learning with this book.
There are other good books on SQL and MySQL as mentioned above.
MySQL Cookbook (2nd Edition) is very useful, for both MySQL and general SQL related problems.
Paul DuBois, MySQL (The Definitive Guide). At Amazon
It's onto the 4th edition now, I have the 3rd and it's excellent.