
Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.
Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.
Sometimes you may need to search JSON array of objects, extract JSON data or retrieve JSON data in MySQL. In this article, we will look at how to query JSON column in MySQL.
Sometimes you may need to prevent duplicate insert while adding rows. Here is how to avoid inserting duplicate records in MySQL.
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.
Sometimes you may need to set timezone to UTC or change timezone to UTC. Here is how to convert datetime to UTC 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.
Sometimes you may need to get date from datetime, or get current datetime. Here is how to get current date and time in MySQL.
MySQL allows you to remove NOT NULL constraint in MySQL. Here is how to remove NOT NULL constraint in MySQL.
Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL