MySQL Guides

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