Sometimes you may need to pass parameter in MySQL query. Here is how to create dynamic SQL queries.
MySQL
How to Disable Strict Mode in MySQL
Strict mode in MySQL controls how invalid or missing values are handled in INSERT, UPDATE & CREATE TABLE queries. Here is how to disable strict mode in MySQL.
MySQL Row Number Function & Its Uses
MySQl Row Number is a very useful window function in MySQL. Here is MySQL Row Number Function & its applications.
How to Comment Multiple Lines in MySQL
How to Setup Loganalyzer with Rsyslog and MySQL
LogAnalyzer provides web-based interface to analyze system logs. Here are the steps to Setup Loganalyzer with Rsyslog and MySQL.
How to Setup Rsyslog with MySQL
Rsyslog is a powerful log management server for Linux. Here is how to setup Rsyslog with MySQL database.
Shell Script to Backup MySQL Database
Often you need to automate taking backup of MySQL database. Here is shell script to backup MySQL database.
How to Change Root Password in MySQL
Sometimes you may need to change root password in MySQL. Here are the steps to reset root password in MySQL.
How to Temporarily Disable Foreign Key Constraint in MySQL
By default, MySQL checks foreign key constraint before deleting a column or truncate a table. Here is how to temporarily disable foreign key constraint in MySQL.
MySQL Compare Databases
Sometimes you may need to compare databases in MySQL. Here’s how to compare databases in MySQL using command line interface.