Learning MySQL and MariaDB

Russell Dyer is a freelance writer specializing in MySQL database software and is the editor of the MySQL Knowledge Base (http://www.mysql.com/network/knowledgeba​se.html). He is the author of MySQL in a Nutshell (http://www.oreilly.com/catalog/mysqlian/) and has writen articles for several magazines: Dev Zone (a MySQL publication), Linux Journal, ONlamp.com, The Perl Journal, Red Hat Magazine, SysAdmin Magazine, Tech Republic, Unix Review, and XML.com. He has also finished his first novel, »In Search of Kafka«.

The Software
Chapter 1 Introduction
The Value of MySQL and MariaDB
Mailing Lists and Forums
Other Books and Other Publications
Chapter 2 Installing MySQL and MariaDB
The Installation Packages
Licensing
Finding the Software
Choosing a Distribution
The _AMP Alternatives
Post-Installation
Chapter 3 The Basics and the mysql Client
The mysql Client
Connecting to the Server
Starting to Explore Databases
Summary
Exercises
Database Structures
Chapter 4 Creating Databases and Tables
Creating a Database
Creating Tables
Inserting Data
More Perspectives on Tables
Summary
Exercises
Chapter 5 Altering Tables
Prudence When Altering Tables
Essential Changes
Optional Changes
Indexes
Summary
Exercises
Basics of Handling Data
Chapter 6 Inserting Data
The Syntax
Practical Examples
Other Possibilities
Summary
Exercises
Chapter 7 Selecting Data
Basic Selection
Selecting by a Criteria
Ordering Results
Limiting Results
Combining Tables
Expressions and the Like
Counting and Grouping Results
Summary
Exercises
Chapter 8 Updating and Deleting Data
Updating Data
Deleting Data
Summary
Exercises
Chapter 9 Joining and Subquerying Data
Unifying Results
Joining Tables
Subqueries
Summary
Exercises
Built-In Functions
Chapter 10 String Functions
Formatting Strings
Extracting Text
Searching Strings and Using Lengths
Converting String Types
Compressing Strings
Summary
Exercises
Chapter 11 Date and Time Functions
Date and Time Data Types
Current Date and Time
Extracting Date and Time Components
Formatting Dates and Time
Adjusting to Standards and Time Zones
Adding and Subtracting Dates and Time
Comparing Dates and Times
Summary
Exercises
Chapter 12 Aggregate and Numeric Functions
Aggregate Functions
Numeric Functions
Summary
Exercises
Administration and Beyond
Chapter 13 User Accounts and Privileges
User Account Basics
Restricting the Access of User Accounts
Administrative User Accounts
Revoking Privileges
Deleting a User Account
Changing Passwords and Names
User Roles
Summary
Exercises
Chapter 14 Backing Up and Restoring Databases
Making Backups
Restoring Backups
Developing a Backup Policy
Summary
Exercises
Chapter 15 Bulk Importing Data
Preparing to Import
Loading Data Basics
Better Loading
More Field and Line Definitions
Importing from Outside MySQL
Bulk Exporting Data
Summary
Exercises
Chapter 16 Application Programming Interfaces
Creating API User Accounts
C API
Perl DBI
PHP API
Python
Ruby API
SQL Injection
Summary
Exercises

Colophon