MySQL Essentials

MySQL Essentials is an online book designed to provide everything a user needs to know to install, build, maintain and secure MySQL based databases.

	Table of Contents	Next
		About MySQL Essentials

---

1. About MySQL Essentials
   
2. Database Basics
   • What is a Database?
   • Understanding Database Tables
   • Introducing Database Schema
   • Columns and Datatypes
   • Database Rows
   • Introducing Primary Keys
   • What is SQL?
     
3. MySQL Database Architecture
   
4. The mysql Command-Line Tool
   • The mysql Command-line Utility
   • mysql Command-Line Arguments
   • mysql Commands
     
5. The MySQL Administrator Tool
   • Getting and Installing MySQL Administrator
   • Connecting to the Database Server
   • Using the MySQL Administator
     
6. The MySQL Query Browser
   • Getting and Installing MySQL Query Browser
   • Connecting the MySQL Query Browser to a Database Server
   • A Tour of MySQL Browser
   • Executing SQL Statements
     
7. Creating New Databases and Tables with MySQL Administrator
   • Creating a New Database
   • Creating New Tables
8. Creating Databases and Tables Using SQL Commands
   • Creating a New MySQL Database
   • Creating Tables with SQL
   • Understanding NULL and NOT NULL Values
   • Primary Keys
   • AUTO_INCREMENT
   • Defining Default Values During Table Creation
   • MySQL Database Engine Types
     
9. Updating and Deleting MySQL Tables
10. Altering a MySQL Table
11. Adding and Deleting Table Columns
12. Renaming Tables and Columns
13. Changing The Data Type of a Column
14. Deleting a Database Table
    

1. Inserting Data into a MySQL Database
   • The Basics of Data Insertion
   • Inserting a Complete Row
   • Adding Multiple Rows to a Table
   • Inserting Results from a SELECT Statement
   • Reducing the INSERT Performance Load
   • Reducing the INSERT Performance Load
     
     

1. Updating and Deleting MySQL Data
   • Updating Database Data
   • Ignoring Update Errors
   • Deleting Database Data
     
     
2. Retrieving Data From a MySQL Database
   • Retrieving a Single Column
   • Using SELECT to Retrieve Mutiple Columns
   • Restricting Number of Results
   • Eliminating Duplicate Values from Results
3. Sorting Data Retrieved from a MySQL Database
4. Using WHERE to Filter MySQL Data
5. Advanced MySQL Data Filtering - AND, OR, NOT and IN
6. MySQL Wildcard Filtering using LIKE
7. MySQL Regular Expression Searches
8. Joining Tables in MySQL
9. An Introduction to MySQL Views
10. MySQL Calculations and Concatenations
11. Manipulating Text in MySQL
12. MySQL Mathematical Functions
13. Working with Dates and Times in MySQL
14. MySQL Data Aggregation Functions
15. MySQL Users and Security

---

	Table of Contents	Next
		About MySQL Essentials