• Data Cleaning Essentials with SQL
• How to Use the LIMIT Clause to Constrain the Number of Rows Returned in MySQL
• How to Use the DISTINCT Keyword to Eliminate Duplicate Rows in MySQL
• How to Use Subqueries in WHERE Clauses in MySQL
• How to Group Query Results with the GROUP BY Clause in MySQL
• How to Use Aliases for Columns and Tables in MySQL Queries
• How to Use Aggregate Functions like COUNT, SUM, and AVG in MySQL
• How to Use LEFT JOIN to Include Non-Matching Rows in MySQL
• How to Join Tables with INNER JOIN in MySQL
• How to Sort Query Results with the ORDER BY Clause in MySQL
• How to Use the WHERE Clause to Filter Query Results in MySQL
• How to Delete Records Using the DELETE Statement in MySQL
• How to Insert Data into Tables with the INSERT Statement in MySQL
• How to Use the SELECT Statement to Query Data in MySQL
• How to Create a New Database in MySQL

This page lists every MySQL tutorial available on Statology.

MySQL: How to Add Column with Default Value
MySQL: How to Add Column After a Specific Column
MySQL: How to Add Column in First Position
MySQL: Add Auto-Increment Column to Existing Table
MySQL: How to Insert Date
MySQL: How to Insert Datetime
MySQL: How to Insert Timestamp
MySQL: How to Return All Rows Between Two Dates
MySQL: How to Return All Rows Greater Than Date
MySQL: How to Return All Rows Less Than Date
MySQL: How to Select Rows where Date is Equal to Today
MySQL: How to Select Rows Where Date is Within Last 30 Days
MySQL: How to Select Rows Where Date is Older Than 7 Days Ago
MySQL: How to Use INSERT INTO From Another Table
MySQL: How to Use DELETE with INNER JOIN
MySQL: How to Delete Rows from Table Based on id
MySQL: How to Delete Duplicate Rows But Keep Latest
MySQL: How to Drop Multiple Columns
MySQL: How to Drop Multiple Tables at Once
MySQL: How to Truncate Strings
MySQL: How to Truncate Dates
MySQL: How to Select Row with Max Value in Column
MySQL: How to Select Row with Max Value by Group
MySQL: How to Check for Null in CASE Statement
MySQL: How to Use Case Statement with Multiple Conditions
MySQL: How to Use Case-Sensitive LIKE Search
MySQL: How to Capitalize First Letter in Strings
MySQL: How to Select First N Characters of String
MySQL: How to Select Last N Rows from Table
MySQL: How to Use SELECT Based on Values from Another SELECT
MySQL: How to Concatenate Rows with Comma
MySQL: How to Add Hours to Datetime
MySQL: How to Add Minutes to Datetime
MySQL: How to Get First Day of Month
MySQL: How to Get First Day of Previous Month
MySQL: How to Get Last Day of Previous Month
MySQL: How to Get First Day of Quarter
MySQL: How to Calculate Difference Between Two Dates
MySQL: How to Add Days to Date
MySQL: How to Add Months to Date
MySQL: How to Do an Inner Join on Multiple Columns
MySQL: How to Do an Inner Join with 3 Tables
MySQL: How to Perform INNER JOIN with WHERE Clause