Sometimes you may need to pass parameter in MySQL query. Here is how to create dynamic SQL queries.
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 is a very useful window function in MySQL. Here is MySQL Row Number Function & its applications.
MySQL supports different types of comments. Here is how to comment multiple lines in MySQL.
LogAnalyzer provides web-based interface to analyze system logs. Here are the steps to Setup Loganalyzer with Rsyslog and MySQL.
Rsyslog is a powerful log management server for Linux. Here is how to setup Rsyslog with MySQL database.
Often you need to automate taking backup of MySQL database. Here is shell script to backup MySQL database.
Sometimes you may need to change root password in MySQL. Here are the steps to reset root password 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.
Sometimes you may need to compare databases in MySQL. Here’s how to compare databases in MySQL using command line interface.