MySQL supports different types of comments. Here is how to comment multiple lines in MySQL.
MySQL
How to Select Random Records in MySQL
Learn 4 different ways to select random records in MySQL. Get random rows using Rand function, Inner Joins and using variables.
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.
How To Create User in MySQL
Many times you may need to create new user for a database in MySQL. Here’s how to create user in MySQL.
Calculate percentile from recency in MySQL
Calculate percentile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders