Sometimes you may need to calculate totals in MySQL. Here’s how to use MySQL rollup to calculate total in MySQL.
How to Use MySQL Rollup
How to Check MySQL Version
It is important to know MySQL version to understand available features and functions. Here’s how to check MySQL version in XAMPP, Workbench, PHPMyAdmin, Terminal.
How to Disable Foreign Key Check in MySQL
Foreign Key constraint check may prevent you from updating database tables. Here’s how to disable foreign key check in MySQL. You can also enable foreign key check afterwards.
How To Create Sequence in MySQL
Sometimes you may need to generate sequence in MySQL. Here’s how to create sequence in MySQL using MySQL sequence query.
How to Compare Two Tables in MySQL
Sometimes you may need to compare two tables in MySQL to find unmatched records or matched records. Here’s how to compare two tables in MySQL.
How To Get Last One Month Data in MySQL
Sometimes you may need to fetch last month record or get rows from previous month. Here’s how to get last one month data in MySQL.
How To Copy Table in MySQL
Sometimes you may need to copy table in MySQL or clone table in MySQL. Here’s how to copy table in MySQL.
How To Add NOT NULL Constraint in MySQL
Sometimes you may need to add NOT NULL constraint in MySQL. Here’s how to add NOT NULL constraint in MySQL.
How To Add Default Constraint in MySQL
Sometimes you may need to add default value to column or add column with default value in MySQL. Here’s how to add default constraint in MySQL.
How to Select Top N Rows Per Group in MySQL
Sometimes you may need to select top n rows per group in MySQL. Here’s how to select to n rows from each category in MySQL.