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

---

eBookFrenzy.com

Purchase and download the full PDF and ePub versions of this MySQL eBook for only $9.99

About MySQL Essentials Database Basics What is a Database? Understanding Database Tables Introducing Database Schema Columns and Datatypes Database Rows Introducing Primary Keys What is SQL? MySQL Database Architecture The mysql Command-Line Tool The mysql Command-line Utility mysql Command-Line Arguments mysql Commands The MySQL Administrator Tool Getting and Installing MySQL Administrator Connecting to the Database Server Using the MySQL Administator 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 Creating New Databases and Tables with MySQL Administrator Creating a New Database Creating New Tables 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 Updating and Deleting MySQL Tables Altering a MySQL Table Adding and Deleting Table Columns Renaming Tables and Columns Changing The Data Type of a Column Deleting a Database Table 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 Updating and Deleting MySQL Data Updating Database Data Ignoring Update Errors Deleting Database Data 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 Sorting Data Retrieved from a MySQL Database Sorting Data from a SELECT Statement Sorting on Multiple Columns Sorting Data in Descending Order Using WHERE to Filter MySQL Data The Basics of the WHERE Clause Comparison Operators Checking for NULL Values Searching within Range Values Advanced MySQL Data Filtering - AND, OR, NOT and IN Filtering Data Using the OR Operator Filtering Data Using the AND Operator Combining AND and OR Operators Understanding Operator Precedence Specifying a Range of Conditions using the IN Clause Using the NOT Operator MySQL Wildcard Filtering using LIKE What are Wildcards? Single Character Wildcards Multiple Character Wildcards MySQL Regular Expression Searches What are Regular Expressions? Regular Expression Character Matching Matching from a Group of Characters Matching from a Range of Characters Handling Special Characters Regular Expressions and Whitespace Characters Matching by Character Type Regular Expression Repetition Metacharacters Matching by Text Position Joining Tables in MySQL How Does a Join Work? Performing a Cross-Join Equi-Join (aka the Inner Join) Performing a Left Join or a Right Join Creating Joins with WHERE and USING An Introduction to MySQL Views Creating a Basic View Joins and Views Getting Information About a View Deleting a View Replacing a View MySQL Calculations and Concatenations Performing Calculations on Retrieved Data Concatenating Data Fields Trimming Trailing Whitespace from Text Trimming Leading Whitespace from Text Manipulating Text in MySQL MySQL String Manipulation Functions MySQL Mathematical Functions MySQL Arithmetic Functions Working with Dates and Times in MySQL Date and Time Formats Creating Date and Time Fields Date and Time Formats Date and Time Functions Inserting Date and Time Values into Table Columns Retrieving Data Based on Date and Time Criteria MySQL Data Aggregation Functions The MySQL Aggregate Functions Using the Aggregate Functions Using the MySQL AVG() Function Using the MySQL COUNT() Function Using the MySQL MAX() Function Using the MySQL MIN() Function Using the SUM() Function Using Multiple Aggregate Functions MySQL Users and Security MySQL Security Getting Information About Users Creating a New MySQL User Deleting a MySQL User Renaming a MySQL User Changing the Password for a MySQL User User Privileges Administering and Monitoring MySQL using the MySQL Workbench Getting and Installing MySQL Workbench Creating a Server Instance Profile Connecting to a MySQL Database Server A Tour of the MySQL Workbench Admin Panel Server Status Configuration Using MySQL Workbench to Execute SQL Queries and Create SQL Scripts Connecting to a MySQL Database Server The MySQL Workbench SQL Editor Using MySQL Workbench to Create a Database Model Creating a New Model Generating a Model Diagram Generating a Script and Creating a Database Reverse Engineering an Existing Database Summary

eBookFrenzy.com

Purchase and download the full PDF and ePub versions of this MySQL eBook for only $9.99

---

	Table of Contents	Next
		About MySQL Essentials