MySQL in 10 minutes / Chris Newman.

Includes bibliographical references and index.

Cover -- TOC36;Contents -- Introduction -- PART 1 MySQL Foundations -- CH36;1 Introducing MySQL -- Database Basics -- About MySQL AB and mysql46;com -- MySQL Components -- Summary -- CH36;2 Using MySQL -- The mysql Client -- Executing SQL Statements -- Creating the Sample Tables -- Summary -- PART 2 Getting Started with SQL -- CH36;3 Retrieving Data -- The SELECT Statement -- Retrieving Database Information -- Summary -- CH36;4 Filtering and Sorting Data -- The WHERE Clause -- The ORDER BY Clause -- Summary -- CH36;5 Advanced Data Filtering -- Combining WHERE Clauses -- Limiting the Number of Rows Returned -- Summary -- CH36;6 Numeric Operators and Functions -- Numeric Operators -- Numeric Functions -- Conditional Functions -- Summary -- CH36;7 String Operators and Functions -- Using Operators with Strings -- String Functions -- Summary -- CH36;8 Date Operators and Functions -- Date Operators -- Date Functions -- Summary -- CH36;9 Summarizing Data -- Aggregate Functions -- Grouping Data -- Filtering Summary Data -- Summary -- PART 3 Advanced SQL -- CH36;10 Using Subqueries -- Understanding Subqueries -- Summary -- CH36;11 Joining Tables -- Understanding Joins -- Summary -- CH36;12 Creating Advanced Joins -- The JOIN Keyword -- Inner Joins -- Joining Multiple Tables -- Cross Joins -- Self45;Joins -- Natural Joins -- Outer Joins -- Summary -- CH36;13 Combining Queries -- Understanding Combined Queries -- Other Compound Operations -- Using Temporary Tables -- Summary -- PART 4 Creating a New Database -- CH36;14 Creating and Modifying Tables -- Creating a New Database -- Character Sets and Collations -- Altering a Database -- Dropping a Database -- Managing Tables -- Temporary Tables -- Using a Query to Create a Table -- Storage Engines -- Altering Tables -- Dropping Tables -- Summary -- CH36;15 Working with Data -- The INSERT Statement -- The DELETE Statement -- The UPDATE Statement -- The REPLACE Statement -- Loading Data from a File -- Why Use Transactions63; -- Transactions in MySQL -- Autocommit Mode -- Rolling Back a Transaction -- Summary -- CH36;16 Designing Your Database -- Relationships -- Normalization -- Naming Tables and Columns -- Data Types -- Summary -- CH36;17 Keys and Indexes -- Understanding Keys and Indexes -- Using Indexes in MySQL -- Summary -- CH36;18 Managing User Access -- Understanding MySQL Authentication -- User Management -- Using Wildcards -- Summary -- PART 5 New Features in MySQL 546;0 -- CH36;19 Views -- Understanding Views -- Summary -- CH36;20 Stored Routines -- Understanding Stored Routines -- Summary -- CH36;21 Triggers -- Understanding Triggers -- Summary -- PART 6 Interfacing with MySQL -- CH36;22 Using ODBC -- Understanding ODBC -- Connecting to MyODBC -- Summary -- CH36;23 Using MySQL with C -- The C Language API -- Summary -- CH36;24 Using MySQL with PHP -- Using the mysql API -- Using the mysqli API -- Summary -- CH36;25 Using MySQL with Perl -- The Perl DBI -- Using the MySQL DBD -- Summary -- PART 7 Appendixes -- T$848.

Now at over 5 million downloads and widely used at all levels, MySQL continues to grow in popularity. Readers are hungry for a concise, easily accessible tutorial on MySQL basics that allows them to get up and running quickly. While there are many MySQL books on the market, there are no up-to-date books that meet this need for the reader. Furthermore, sales of MySQL books clearly shows the need for a concise, handy tutorial versus the more bulky introductions to MySQL. Sams Teach Yourself MySQL in 10 Minutes provides a no-fluff, just-the-answers guide to building and managing MySQL databases.