Changes

MySQL Essentials

4,562 bytes added, 18:05, 29 October 2007
no edit summary
# [[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|Deleting a Database Table]]<br><br>
# [[Inserting Data into a MySQL Database]]
#* [[Inserting Data into a MySQL Database|The Basics of Data Insertion]]
#* [[Inserting Data into a MySQL Database|Reducing the INSERT Performance Load]]
#* [[Inserting Data into a MySQL Database|Reducing the INSERT Performance Load]]<br><br>
 
# [[Updating and Deleting MySQL Data]]
#* [[Updating and Deleting MySQL Data|Updating Database Data]]
#* [[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|Eliminating Duplicate Values from Results]]<br><br>
# [[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|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|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|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|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|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|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|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|MySQL String Manipulation Functions]]<br><br>
# [[MySQL Mathematical Functions]]
#* [[MySQL Mathematical Functions|MySQL Arithmetic Functions]]
# [[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|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 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>