MySQL allows you to save JSON data. Here is how to store JSON data in MySQL.
It can be time-consuming to take full database backup every time in MySQL. Here is how to do incremental backup in MySQL using binary log.
MySQL supports InnoDB and MyISAM. Here is how to change table engine from InnoDB to MyISAM.
MySQL Datetime & Timestamp are two useful data types. Here are the key differences between the two data types in MySQL.
Python allows you to load data into databases and run SQL queries. Here is the python script to load data in MySQL.
Sometimes you may need to populate MySQL table with random data. Here are the steps to do it.
It is good to keep track of query execution time of SQL queries in MySQL. Here is how to get query execution time in MySQL.
Sometimes database administrators need to view active connections per user in MySQL. Here are the steps to do it.
Sometimes you may need to view all open connections to MySQL database. Here is how to show all open database connections to MySQL database.
Sometimes you may need to revoke privileges for users in MySQL. Here is how to revoke user privileges in MySQL.