MySQL
MySQL, Powered for Insights: Learn with DataReportive.
This tutorial walks you through MySQL from basics to advanced reporting. Discover how to structure, query, and optimize your data to fuel smarter dashboards, reports, and analytics—directly aligned with real-world use cases from the DataReportive platform.
Database Management
How to Add an IndexHow to Create a Table
How to Delete a Table
How to Rename a Table
How to Truncate a Table
How to Duplicate a Table
How to Add a Column
How to Remove a Column
How to Change a Column Name
How to Set a Column with Default Value
How to Remove a Default Value to a Column
How to Add a Not Null Constraint
How to Remove a Not Null Constraint
How to Drop an Index
How to Create a View
How to Drop a View
How to Alter Sequence
Dates and Times
How to Round TimestampsHow to Query Date and Time
How to Group by Time
How to Convert UTC to Local Time Zone
Analysis
How to Use CoalesceHow to Calculate Percentiles
How to Get the First Row per Group
How to Avoid Gaps in Data
How to Do Type Casting
How to Write a Common Table Expression
How to Import a CSV
How to Compare Two Values When One is Null
How to Write a Case Statement
How to Query a JSON Column
How to Have Multiple Counts
How to Calculate Cumulative Sum-Running Total