Difference between revisions of "MySQL Essentials"
From Techotopia
| Line 48: | Line 48: | ||
# [[Updating and Deleting MySQL Tables|Renaming Tables and Columns]] | # [[Updating and Deleting MySQL Tables|Renaming Tables and Columns]] | ||
# [[Updating and Deleting MySQL Tables|Changing The Data Type of a Column]] | # [[Updating and Deleting MySQL Tables|Changing The Data Type of a Column]] | ||
| − | # [[Updating and Deleting MySQL Tables|Deleting a Database Table]]<br> | + | # [[Updating and Deleting MySQL Tables|Deleting a Database Table]]<br><br> |
| − | + | ||
# [[Inserting Data into a MySQL Database]] | # [[Inserting Data into a MySQL Database]] | ||
#* [[Inserting Data into a MySQL Database|The Basics of Data Insertion]] | #* [[Inserting Data into a MySQL Database|The Basics of Data Insertion]] | ||
| Line 57: | Line 56: | ||
#* [[Inserting Data into a MySQL Database|Reducing the INSERT Performance Load]] | #* [[Inserting Data into a MySQL Database|Reducing the INSERT Performance Load]] | ||
#* [[Inserting Data into a MySQL Database|Reducing the INSERT Performance Load]]<br><br> | #* [[Inserting Data into a MySQL Database|Reducing the INSERT Performance Load]]<br><br> | ||
| − | |||
# [[Updating and Deleting MySQL Data]] | # [[Updating and Deleting MySQL Data]] | ||
#* [[Updating and Deleting MySQL Data|Updating Database Data]] | #* [[Updating and Deleting MySQL Data|Updating Database Data]] | ||
| Line 66: | Line 64: | ||
#* [[Retrieving Data From a MySQL Database|Using SELECT to Retrieve Mutiple Columns]] | #* [[Retrieving Data From a MySQL Database|Using SELECT to Retrieve Mutiple Columns]] | ||
#* [[Retrieving Data From a MySQL Database|Restricting Number of Results]] | #* [[Retrieving Data From a MySQL Database|Restricting Number of Results]] | ||
| − | #* [[Retrieving Data From a MySQL Database|Eliminating Duplicate Values from Results]] | + | #* [[Retrieving Data From a MySQL Database|Eliminating Duplicate Values from Results]]<br><br> |
# [[Sorting Data Retrieved from a MySQL Database]] | # [[Sorting Data Retrieved from a MySQL Database]] | ||
| + | #* [[Sorting Data Retrieved from a MySQL Database|Sorting Data from a SELECT Statement]] | ||
| + | #* [[Sorting Data Retrieved from a MySQL Database|Sorting on Multiple Columns]] | ||
| + | #* [[Sorting Data Retrieved from a MySQL Database|Sorting Data in Descending Order]]<br><br> | ||
# [[Using WHERE to Filter MySQL Data]] | # [[Using WHERE to Filter MySQL Data]] | ||
| + | #* [[Using WHERE to Filter MySQL Data|The Basics of the WHERE Clause]] | ||
| + | #* [[Using WHERE to Filter MySQL Data|Comparison Operators]] | ||
| + | #* [[Using WHERE to Filter MySQL Data|Checking for NULL Values]] | ||
| + | #* [[Using WHERE to Filter MySQL Data|Searching within Range Values]]<br><br> | ||
# [[Advanced MySQL Data Filtering - AND, OR, NOT and IN]] | # [[Advanced MySQL Data Filtering - AND, OR, NOT and IN]] | ||
| + | #* [[Advanced MySQL Data Filtering - AND, OR, NOT and IN|Filtering Data Using the OR Operator]] | ||
| + | #* [[Advanced MySQL Data Filtering - AND, OR, NOT and IN|Filtering Data Using the AND Operator]] | ||
| + | #* [[Advanced MySQL Data Filtering - AND, OR, NOT and IN|Combining AND and OR Operators]] | ||
| + | #* [[Advanced MySQL Data Filtering - AND, OR, NOT and IN|Understanding Operator Precedence]] | ||
| + | #* [[Advanced MySQL Data Filtering - AND, OR, NOT and IN|Specifying a Range of Conditions using the IN Clause]] | ||
| + | #* [[Advanced MySQL Data Filtering - AND, OR, NOT and IN|Using the NOT Operator]]<br><br> | ||
# [[MySQL Wildcard Filtering using LIKE]] | # [[MySQL Wildcard Filtering using LIKE]] | ||
| + | #* [[MySQL Wildcard Filtering using LIKE|What are Wildcards?]] | ||
| + | #* [[MySQL Wildcard Filtering using LIKE|Single Character Wildcards]] | ||
| + | #* [[MySQL Wildcard Filtering using LIKE|Multiple Character Wildcards]]<br><br> | ||
# [[MySQL Regular Expression Searches]] | # [[MySQL Regular Expression Searches]] | ||
| + | #* [[MySQL Regular Expression Searches|What are Regular Expressions?]] | ||
| + | #* [[MySQL Regular Expression Searches|Regular Expression Character Matching]] | ||
| + | #* [[MySQL Regular Expression Searches|Matching from a Group of Characters]] | ||
| + | #* [[MySQL Regular Expression Searches|Matching from a Range of Characters]] | ||
| + | #* [[MySQL Regular Expression Searches|Handling Special Characters]] | ||
| + | #* [[MySQL Regular Expression Searches|Regular Expressions and Whitespace Characters]] | ||
| + | #* [[MySQL Regular Expression Searches|Matching by Character Type]] | ||
| + | #* [[MySQL Regular Expression Searches|Regular Expression Repetition Metacharacters]] | ||
| + | #* [[MySQL Regular Expression Searches|Matching by Text Position]]<br><br> | ||
# [[Joining Tables in MySQL]] | # [[Joining Tables in MySQL]] | ||
| + | #* [[Joining Tables in MySQL|How Does a Join Work?]] | ||
| + | #* [[Joining Tables in MySQL|Performing a Cross-Join]] | ||
| + | #* [[Joining Tables in MySQL|Equi-Join (aka the Inner Join)]] | ||
| + | #* [[Joining Tables in MySQL|Performing a Left Join or a Right Join]] | ||
| + | #* [[Joining Tables in MySQL|Creating Joins with WHERE and USING]]<br><br> | ||
# [[An Introduction to MySQL Views]] | # [[An Introduction to MySQL Views]] | ||
| + | #* [[An Introduction to MySQL Views|Creating a Basic View]] | ||
| + | #* [[An Introduction to MySQL Views|Joins and Views]] | ||
| + | #* [[An Introduction to MySQL Views|Getting Information About a View]] | ||
| + | #* [[An Introduction to MySQL Views|Deleting a View]] | ||
| + | #* [[An Introduction to MySQL Views|Replacing a View]]<br><br> | ||
# [[MySQL Calculations and Concatenations]] | # [[MySQL Calculations and Concatenations]] | ||
| + | #* [[MySQL Calculations and Concatenations|Performing Calculations on Retrieved Data]] | ||
| + | #* [[MySQL Calculations and Concatenations|Concatenating Data Fields]] | ||
| + | #* [[MySQL Calculations and Concatenations|Trimming Trailing Whitespace from Text]] | ||
| + | #* [[MySQL Calculations and Concatenations|Trimming Leading Whitespace from Text]]<br><br> | ||
# [[Manipulating Text in MySQL]] | # [[Manipulating Text in MySQL]] | ||
| + | #* [[Manipulating Text in MySQL|MySQL String Manipulation Functions]]<br><br> | ||
# [[MySQL Mathematical Functions]] | # [[MySQL Mathematical Functions]] | ||
| + | #* [[MySQL Mathematical Functions|MySQL Arithmetic Functions]] | ||
# [[Working with Dates and Times in MySQL]] | # [[Working with Dates and Times in MySQL]] | ||
| + | #* [[Working with Dates and Times in MySQL|Date and Time Formats]] | ||
| + | #* [[Working with Dates and Times in MySQL|Creating Date and Time Fields]] | ||
| + | #* [[Working with Dates and Times in MySQL|Date and Time Formats]] | ||
| + | #* [[Working with Dates and Times in MySQL|Date and Time Functions]] | ||
| + | #* [[Working with Dates and Times in MySQL|Inserting Date and Time Values into Table Columns]] | ||
| + | #* [[Working with Dates and Times in MySQL|Retrieving Data Based on Date and Time Criteria]]<br><br> | ||
# [[MySQL Data Aggregation Functions]] | # [[MySQL Data Aggregation Functions]] | ||
| + | #* [[MySQL Data Aggregation Functions|The MySQL Aggregate Functions]] | ||
| + | #* [[MySQL Data Aggregation Functions|Using the Aggregate Functions]] | ||
| + | #* [[MySQL Data Aggregation Functions|Using the MySQL AVG() Function]] | ||
| + | #* [[MySQL Data Aggregation Functions|Using the MySQL COUNT() Function]] | ||
| + | #* [[MySQL Data Aggregation Functions|Using the MySQL MAX() Function]] | ||
| + | #* [[MySQL Data Aggregation Functions|Using the MySQL MIN() Function]] | ||
| + | #* [[MySQL Data Aggregation Functions|Using the SUM() Function]] | ||
| + | #* [[MySQL Data Aggregation Functions|Using Multiple Aggregate Functions]]<br><br> | ||
# [[MySQL Users and Security]] | # [[MySQL Users and Security]] | ||
| + | #* [[MySQL Users and Security|MySQL Security]] | ||
| + | #* [[MySQL Users and Security|Getting Information About Users]] | ||
| + | #* [[MySQL Users and Security|Creating a New MySQL User]] | ||
| + | #* [[MySQL Users and Security|Deleting a MySQL User]] | ||
| + | #* [[MySQL Users and Security|Renaming a MySQL User]] | ||
| + | #* [[MySQL Users and Security|Changing the Password for a MySQL User]] | ||
| + | #* [[MySQL Users and Security|User Privileges]] | ||
<hr> | <hr> | ||
Revision as of 18:05, 29 October 2007
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 |
- About MySQL Essentials
- Database Basics
- MySQL Database Architecture
- The mysql Command-Line Tool
- The MySQL Administrator Tool
- The MySQL Query Browser
- Creating New Databases and Tables with MySQL Administrator
- Creating Databases and Tables Using SQL Commands
- 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
- Updating and Deleting MySQL Data
- Retrieving Data From a MySQL Database
- Sorting Data Retrieved from a MySQL Database
- Using WHERE to Filter MySQL Data
- Advanced MySQL Data Filtering - AND, OR, NOT and IN
- MySQL Wildcard Filtering using LIKE
- 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
- An Introduction to MySQL Views
- MySQL Calculations and Concatenations
- Manipulating Text in MySQL
- MySQL Mathematical Functions
- Working with Dates and Times in MySQL
- MySQL Data Aggregation Functions
- MySQL Users and Security
| Table of Contents | Next | |
| About MySQL Essentials |
