Sometimes you may need to cast as boolean in MySQL. Here’s how to cast string as boolean and cast int as boolean.
MySQL Cast as Boolean
MySQL
MySQL CAST vs CONVERT
MySQL Convert Function
Sometimes you may need to convert data in MySQL. Here’s how to convert data in MySQL using MySQL convert function.
MySQL CAST – How to Type Cast in MySQL
Sometimes you may need to typecast one data into another in MySQL. Here’s how to cast data using MySQL CAST function.
MySQL Rollback Query
Sometimes you may need to undo MySQL changes for your databases. Here’s how to rollback changes using MySQL Rollback query command.
How to Use MySQL Rollup
Sometimes you may need to calculate totals in MySQL. Here’s how to use MySQL rollup to calculate total in MySQL.
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.