MySQL Books | Sue Brandreth's Learning Resources

DuBois, P. (2005) MySQL: the Definitive Guide to Using, Programming, and Administering MySQL 4.1 and 5.0 (Developer’s Library), Third Edition, Sams Publishing

A newer edition of this book is available

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!

Introduction.
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.
Additional Resources.
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.
Structural Terminology.
Query Language Terminology.
MySQL Architectural Terminology.
A MySQL Tutorial.
Obtaining the Sample Database Distribution.
Preliminary Requirements.
Establishing and Terminating Connections to the MySQL Server.
Executing SQL Statements.
Creating a Database.
Creating Tables.
Adding New Records.
Resetting the sampdb Database to a Known State.
Retrieving Information.
Deleting or Updating Existing Records.
Tips for Interacting with mysql.
Simplifying the Connection Process.
Issuing Statements with Less Typing.
Where to Now?
2. MySQL SQL Syntax and Use.
MySQL Naming Rules.
Referring to Elements of Databases.
Case Sensitivity in SQL Statements.
The Server SQL Mode.
Character Set Support.
Character Set Support Before MySQL 4.amp;nbsp; Obtaining and Installing a MySQL Distribution on Unix.
Post-Installation Steps.
Installing Perl DBI Support on Unix.
Installing Apache and PHP on Unix.
Installing MySQL on Windows.
Installing Perl DBI Support on Windows.
Installing Apache and PHP on Windows.
Installing Connector/ODBC on Windows.
Appendix B. Data Type Reference.
Numeric Types.
Integer Types.
Floating-Point Types.
Fixed-Point Type.
BIT Type.
String Types.
Binary String Types.
Non-Binary String Types.
ENUM and SET Types.
Date and Time Types.
Spatial Types.
Appendix C. Operator and Function Reference.
Operators.
Operator Precedence.
Grouping Operators.
Arithmetic Operators.
Comparison Operators.
Bit Operators.
Logical Operators.
Cast Operators.
Pattern-Matching Operators.
Functions.
Comparison Functions.
Cast Functions.
Numeric Functions.
String Functions.
Date and Time Functions.
Summary Functions.
Security and Compression Functions.
Advisory Locking Functions.
Spatial Functions.
Miscellaneous Functions.
Appendix D. System, Status, and User Variable Reference.
System Variables.
Session-Only System Variables.
Status Variables.
Statement Counter Status Variables.
InnoDB Status Variables.
Query Cache Status Variables.
SSL Status Variables.
User-Defined Variables.
Appendix E. SQL Syntax Reference.
SQL Statement Syntax.
Stored Routine Syntax.
Control Structure Statements.
Declaration Statements.
Cursor Statements.
Comment Syntax.
Appendix F. MySQL Program Reference.
Specifying Program Options.
Program Option Conventions.
Standard MySQL Program Options.
Option Files.
Environment Variables.
libmysqld.
myisamchk.
Usage.
Standard Options Supported by myisamchk.
Options Specific to myisamchk.
Variables for myisamchk.
myisampack.
Usage.
Standard Options Supported by myisampack.
Options Specific to myisampack.
mysql.
Usage.
Standard Options Supported by mysql.
Options Specific to mysql.
Variables for mysql.
mysql Commands.
mysql Prompt Definition Sequences.
mysql.server.
Usage.
Standard Options Supported by mysql.server.
mysql_config.
Usage.
Options Specific to mysql_config.
mysql_install_db.
Usage.
Options Specific to mysql_install_db.
mysqladmin.
Usage.
Standard Options Supported by mysqladmin.
Options Specific to mysqladmin.
Variables for mysqladmin.
mysqladmin Commands.
mysqlbinlog.
Usage.
Standard Options Supported by mysqlbinlog.
Options Specific to mysqlbinlog.
Variables for mysqlbinlog.
mysqlcheck.
Usage.
Standard Options Supported by mysqlcheck.
Options Specific to mysqlcheck.
mysqld.
Usage.
Standard Options Supported by mysqld.
Options Specific to mysqld.
Variables for mysqld.
mysqld_multi.
Usage.
Standard Options Supported by mysqld_multi.
Options Specific to mysqld_multi.
mysqld_safe.
Usage.
Options Specific to mysqld_safe.
Upgrading Tips.
mysqldump.
Usage.
Standard Options Supported by mysqldump.
Options Specific to mysqldump.
Data Format Options for mysqldump.
Variables for mysqldump.
mysqlhotcopy.
Usage.
Standard Options Supported by mysqlhotcopy.
Options Specific to mysqlhotcopy.
mysqlimport.
Usage.
Standard Options Supported by mysqlimport.
Options Specific to mysqlimport.
Data Format Options for mysqlimport.
mysqlshow.
Usage.
Standard Options Supported by mysqlshow.
Options Specific to mysqlshow.
perror.
Usage.
Standard Options Supported by perror.
Appendix G. C API Reference.
Compiling and Linking.
C API Data Types.
Scalar Data Types.
Non-Scalar Data Types.
Accessor Macros.
C API Functions.
Connection Management Routines.
Error-Reporting Routines.
Statement Construction and Execution Routines.
Result Set Processing Routines.
Information Routines.
Transaction Control Routines.
Multiple Result Set Routines.
Prepared Statement Routines.
Administrative Routines.
Threaded Client Routines.
Embedded Server Communication Routines.
Debugging Routines.
Appendix H. Perl DBI API Reference.
Writing Scripts.
DBI Methods.
DBI Class Methods.
Database Handle Methods.
Statement Handle Methods.
General Handle Methods.
MySQL-Specific Administrative Methods.
DBI Utility Functions.
DBI Attributes.
Database Handle Attributes.
General Handle Attributes.
MySQL-Specific Database Handle Attributes.
Statement Handle Attributes.
MySQL-Specific Statement Handle Attributes.
Dynamic Attributes.
DBI Environment Variables.
Appendix I. PHP and PEAR DB API Reference.
Writing PHP Scripts.
PEAR DB Module Classes.
PEAR DB Module Methods.
DB Class Methods.
DB_common Object Methods.
DB_result Object Methods.
DB_Error Object Methods.
Index.

Meloni, J. C. (2002) Sams Teach Yourself MySQL in 24 Hours, Sams Publishing

Sams Teach Yourself MySQL in 24 Hours teaches the reader everything from basic installation to using MySQL in Web application development.

First, the basic concepts of database design are taught, and then the reader jumps right into planning and creating a database. The book then walks the reader through all the basics of using MySQL – working with tables and data, using MySQL’s query functions, using transactions, and database administration – before the reader finally learns to put everything together to properly create the foundation database for a Web-based application.

Table of Contents

(NOTE: Each chapter concludes with a Summary, Q&A, and Workshop.)

Introduction.

I. INTRODUCTION TO MYSQL AND RELATIONAL DATABASES.

Hour 1. Introducing MySQL.
What Is a Relational Database? What Is MySQL? Communicating with MySQL.Hour 2. Understanding Database Terminology.
Basic Elements Explained.Hour 3. Learning the Database Design Process.
The Importance of Good Database Design. Types of Table Relationships. Understanding Normalization. Following the Design Process.II. SETTING UP YOUR ENVIRONMENT.

Hour 4. Using the MySQL Client.
Working with the MySQL Command-Line Interface. Working with the MySQL Administration Tools. Other Interfaces to MySQL.Hour 5. Securing MySQL.
Basic Security Guidelines. Introducing the MySQL Privilege System. Working with User Provileges.III. LEARNING TO PLAN FOR YOUR DATABASE-DRIVEN APPLICATIONS.

Hour 6. Planning and Creating Your Database.
Determine Your Goals. Conceptualize the Tables. Creating the Database.Hour 7. Creating Your Database Tables-Part I.
Learning the MySQL Data Types. Learning the Table Creation Syntax.Hour 8. Creating Your Database Tables-Part II.
Identifying Keys in Your Tables. Adding Indexes to Your Tables. When to Use, or Not to Use, Keys and Indexes. Finalizing Your Table Creation Statements. Issuing Your Table Creation Statements.IV. WORKING WITH YOUR TABLES.

Hour 9. Populating Your Database Tables.
Using the INSERT Command. Importing Data from Other Databases.Hour 10. Selecting Data from Your Tables.
Using the SELECT Command. Using WHERE in Your Queries. Using Operators in WHERE Clauses. String Comparison Using LIKE.Hour 11. Advanced Usage of SELECT Statements.
Using the GROUP BY Clause. Using SELECT Within INSERT Statements. Selecting from Multiple Tables. Using JOIN.Hour 12. Modifying and Deleting Data.
Using the UPDATE Command to Modify Records. Using the REPLACE Command. Using the DELETE Command.Hour 13. More About DELETE.
Deleting Related Records. Listing Tables and Databases Before Deleting Them. Using the DROP Command.Hour 14. Modifying Table Structure.
Using DESCRIBE to View Table Structure. Renaming Tables. Using the ALTER Command.V. USING BUILT-IN FUNCTIONS IN MYSQL QUERIES.

Hour 15. Using MySQL String Functions.
Frequently Used String Functions. Obscure String Functions.Hour 16. Using MySQL Numeric Functions.
Using Numeric Functions in Queries.Hour 17. Using MySQL Date and Time Functions.
Using Date and Time Functions in Queries. Formatting Dates and Times. Performing Date Arithmetic. Special Functions and Conversion Features.VI. USING TRANSACTIONS.

Hour 18. Transactions Overview.
What Are Transactions? Transaction-Safe Table Types in MySQL.Hour 19. Practical Transaction Usage.
Converting Tables to Transaction-Safe Table Types. Using Transactions in Your Applications.VII. ADMINISTERING YOUR MYSQL SERVER.

Hour 20. Optimizing and Tuning Your Database.
Building an Optimized Platform. MySQL Startup Options. Optimizing Your Table Structure. Optimizing Your Queries.Hour 21. Backing Up and Restoring Your Database.
Database Backup Overview. Using mysqlhotcopy. Using the BACKUP TABLE and RESTORE TABLE Commands. Using myisamchk.Hour 22. Basic Administrative Commands.
Using the FLUSH Command. Using the SHOW Command.VIII. INTERFACING WITH MYSQL.

Hour 23. Using MySQL with Perl.
Getting Access to Perl. Connecting to MySQL with Perl. Executing Queries. Working with MySQL Data.Hour 24. Using MySQL with PHP.
Getting Access to PHP. How PHP Works. Connecting to MySQL with PHP. Working with MySQL Data.IX. APPENDICES.

Appendix A. Installing MySQL.
How to Get MySQL. Installing MySQL 3.23 or 4.0 on Windows. Installing MySQL 3.23 or 4.0 on Linux/UNIX. Troubleshooting Your Installation.Appendix B. Using MyODBC.
Installing MyODBC on Windows. Configuring MyODBC. Importing/Exporting Data with MysQL and Microsoft Access.Appendix C. Reserved Words.
Appendix D. Practical MySQL/PHP Examples.
Creating Access Logs and Reports. Creating an Online Poll. Storing Uploaded Files in Your Database. Retrieving Images Files from Your Database.

Ullman, L. (2006) Visual QuickStart Guide MySQL, Second Edition, Peachpit Press

Download Source Code (ZIP 31KB)

Companion Web Site: http://www.larryullman.com/books/mysql-visual-quickstart-guide-2nd-edition/

Even if you’ve never used MySQL before, this Visual QuickStart Guide will have you up and running with the world’s most popular open source database application in no time. In this completely updated edition of our best-selling guide to MySQL, leading technology authorLarry Ullman uses his trademark crystal-clear instructions and friendly prose to introduce you to everything that’s new in MySQL. Filled with step-by-step, task-based instructions and loads of visual aids, this book explains how to interact with MySQL using SQL, the language common to all databases. The interface examples show how to use MySQL’s own tools and how to use three popular programming languages (PHP, Perl, and Java). The book covers MySQL versions 3 and 4, as well as everything new in the eagerly anticipated version 5. Along the way, you’ll find extensive coverage of MySQL installation, administration, database design, as well as its use with various programming languages, database programming techniques, utilities, advanced MySQL and SQL, and more!

•   Takes an easy, visual approach to teaching MySQL, using pictures to guide you through the software and show you what to do.
•   Works like a reference book―you look up what you need and then get straight to work.
•   No long-winded passages―concise, straightforward commentary explains what you need to know.
•   Affordably priced, because buying a computer book shouldn’t be an investment in itself.
•   Companion Web site at www.DMCInsights.com/mysql2 contains complete source code for examples in the book, online resources, extra scripts and tutorials, updates, a reader forum, and more.

Introduction
Chapter 1: Installing MySQL
- General Installation Steps
- Installing MySQL on Windows
- Configuring MySQL on Windows
- Installing MySQL on Macintosh
- Installing MySQL on Linux
- Basic Configuration Options
- Upgrading MySQL
Chapter 2: Running MySQL
- Running MySQL on Windows and Windows NT
- Running MySQL on Mac OS X
- Running MySQL on Linux and Unix
- Using mysqladmin
- Setting the Root User Password
- Using the mysql Client
- Users and Privileges
Chapter 3: Database Design
- Normalization
- Understanding Keys
- Understanding Relationships
- First Normal Form
- Second Normal Form
- Third Normal Form
Chapter 4: Creating a MySQL Database
- MySQL Data Types
- Extra Column Characteristics
- Introduction to Indexes
- Finalizing a Table’s Design
- Choosing a Storage Engine
- Character Sets and Collations
- Creating Databases
- Creating Tables
- Modifying Tables
Chapter 5: Basic SQL
- Using Values in Queries
- Inserting Dtaa
- Selecting Data
- Using Conditionals
- Using LIKE and NOT LIKE
- Performing Joins
- Sorting Query Results
- Limiting Query Results
- Updating Data
- Deleting Data
Chapter 6: MySQL Functions
- Text Functions
- Concatenation and Aliases
- Numeric Functions
- Date and Time Functions
- Formatting the Date and Time
- Encryption Functions
- Grouping Functions
- Other Functions
Chapter 7: MySQL and PHP
- Connecting to MySQL and Selecting a Database
- Executing Simple Queries
- Retrieving Query Results
- Using mysql_insert_id()
- Error Handling
- Security Considerations
Chapter 8: MySQL and Perl
- Installing Perl with MySQL Support on Windows
- Installing Perl Support for MySQL on Unix and Mac OS X
- Testing Perl and MySQL
- Connecting to MySQL
- Retrieving Query Results
- Executing Simple Queries
- Retrieving the Insert ID
- Error Handling
- Security Considerations
- Using Prepared Statements
Chapter 9: MySQL and Java
- Installing Java Support for MySQL
- Connecting to the Database
- Executing Simple Queries
- Retrieving Query Results
- Retrieving the Insert ID
- Using Prepared Statements
Chapter 10: Advanced SQL and MySQL
- Performing Transactions
- Full-Text Searching
- Regular Expressions
- User-Defined Variables
- Introducing Unions
Chapter 11: MySQL 5 Features
- Stored Routines
- Using OUT Parameters
- Triggers
- Views
Chapter 12: Techniques for Programming
- Storing and Retrieving Binary Data
- Making Query Result Pages
- Using Transactions with Perl
Chapter 13: MySQL Administration
- The MySQL Administrator
- Backing Up Databases
- Importing Data
- MySQL Logging
- Database Maintenance
- Improving Performance
- Using Batch Files
Appendix A: Troubleshooting
- Installation
- Starting MySQL
- Accessing MySQL
- mysql.sock Problems
- Queries That Return Strange Results
- Authentication Protocol Problems
- Resetting the Root Password
Appendix B: SQL and MySQL References
- Basic SQL
- ALTER Commands
- SQL Clauses
- MySQL Privileges
- MySQL Data Types
- MySQL Functions
- Other References
Appendix C: Resources
- MySQL-Specific
- Third-Party MySQL Applications
- SQL
- PHP
- Perl
- Java
- Other

Dubois, P., Hinz, S. and Pederson, C. (2005) MySQL 5.0 Certification Study Guide, MySQL Press

This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. The number of MySQL certification exams taken has doubled in the last six months.

Certcities.com lists the MySQL certification as one of the top 10 certifications to grow in 2005. MySQL professionals need a way to distinguish themselves from the vast majority of database administrators and developers. With more than 4 million active installations, MySQL is the world’s most popular open-source database. Known for its speed, reliability and case of use, MySQL has become a low-cost alternative to expensive database systems such as Oracle, IBM and Microsoft. MySQL AB has aggressively improved the feature set of MySQL with MySQL 5, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, available at over 3,000 PearsonVUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators and programmers.

The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.

Table of Contents

Introduction.

About This Book.

Sample Exercises