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]]

# [[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]]

# [[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]]

# [[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]]

# [[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]]

# [[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]]

# [[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]]

# [[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]]

# [[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]]

# [[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]]

# [[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]]

# [[Manipulating Text in MySQL]]

#* [[Manipulating Text in MySQL|MySQL String Manipulation Functions]]

# [[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]]

# [[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]]

# [[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>

Neil

Bureaucrat, administrator

34,333

edits

Changes

MySQL Essentials

Techotopia