Sometimes you may need to select multiple count in one query or get multiple counts for different criteria. Here is how to get multiple counts with single query in MySQL.
How to Get Multiple Counts With Single Query in MySQL
MySQL
How to Convert datetime to UTC in MySQL
Sometimes you may need to set timezone to UTC or change timezone to UTC. Here is how to convert datetime to UTC in MySQL
How to Convert UTC to Local Time in MySQL
Sometimes you may need to change UTC to local time in MySQL. Here is how to convert UTC to local time in MySQL.
How to Get Current Date and Time in MySQL
Sometimes you may need to get date from datetime, or get current datetime. Here is how to get current date and time in MySQL.
How to Group By Month in 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.