Sometimes you may need to aggregate by month in MySQL. Here is how to group by month in MySQL.
MySQL
How to Remove Not Null Constraint in MySQL
MySQL allows you to remove NOT NULL constraint in MySQL. Here is how to remove NOT NULL constraint in MySQL.
How to Remove Default Value of Column in MySQL
Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL
How to Round Timestamp in MySQL
Sometimes you need to round timestamp to hour, minute, day, seconds, month. Here is how to round timestamp in MySQL
How To Rename Table in MySQL
How to Run Multiple MySQL Instances on Same Machine
Sometimes you may need to run multiple MySQL server on single machine. Here is how to run multiple MySQL instances on same machine.
How to Insert Multiple Rows in MySQL
Sometimes you may need to insert multiple rows in MySQL. Here is how to insert multiple rows in MySQL.
How To Update a Column Based on Another Column in SQL
How to Escape Single Quote, Special Characters in MySQL
Sometimes you may need to store string with single quote, double quote, backticks and special characters. Here is how to escape single quote, special characters in MySQL.
How to Store JSON Data in MySQL
MySQL allows you to store JSON data, insert JSON string into MySQL, and extract JSON. Here is how to store JSON data in MySQL.