A new edition of this title is available, ISBN-10: 0672329387 ISBN-13: 9780672329388
For years, MySQL has been helping MySQL developers and database administrators learn their MySQL system inside and out. This newest edition has been updated to include information on MySQL 5 and it will prove itself again to you as being the most definitive reference guide to using, administering and programming MySQL databases. You'll learn everything from the basics to using MySQL to generate dynamic web pages to administering MySQL servers. This edition has been reviewed by the top developers in the MySQL community and the changes reflect their feedback, as well as the feedback of many other readers, and it has turned out to be the most comprehensive, thorough edition of MySQL to date. Don't go to work without it!
Paul DuBois maintains a book companion web site where you can find the latest code samples, errata, and general information for MySQL, Third Edition. Please go to www.kitebird.com/mysql-book/ to access the book companion web site.
Why Choose MySQL?
Already Running Another RDBMS?
Tools Provided with MySQL.
What You Can Expect from This Book.
Road Map to This Book.
Part I: General MySQL Use.
Part II: Using MySQL Programming Interfaces.
Part III: MySQL Administration.
Part IV: Appendixes.
How to Read This Book.
Versions of Software Covered in This Book.
Conventions Used in This Book.
1. Getting Started with MySQL and SQL.
How MySQL Can Help You.
A Sample Database.
The U.S. Historical League.
The Grade-Keeping Project.
How the Sample Database Applies to You.
Basic Database Terminology.
Query Language Terminology.
MySQL Architectural Terminology.
A MySQL Tutorial.
Obtaining the Sample Database Distribution.
Establishing and Terminating Connections to the MySQL Server.
Executing SQL Statements.
Creating a Database.
Adding New Records.
Resetting the sampdb Database to a Known State.
Note: You will need the Free Adobe Acrobat Reader to view the file(s) for the book. If you do not already have Acrobat installed on your machine, click the "Get Acrobat Reader" button to download and install.
Click on the links below to display the PDF file in a new window. Right-click on the link and select Save As if you want to download it to your hard drive.
0672326736errata.pdf (49 KB)