You can use Percona XtraBackup to perform a physical backup of a MySQL datadir without stopping client access. This backup process is much faster than using mysqldump.
Category: MySQL
DATE_FORMAT Function – MySQL
The DATE_FORMAT function assists in formatting the specified/provided date. Depending on the report criteria and geolocation, we may be required to return the date in
Find number of days in the month – MySQL
The following query will provide the month’s number of days for the specified date. This will come in handy if we need to figure out
SHOW CREATE DATABASE in Apache Hive
In Apache Hive, unlike MySQL or any other RDBMS, there is no SHOW CREATE DATABASE statement. At the very least, not in a direct way.
MySQL SHOW Commands
In this post, we will be discussing the most frequently used admin commands specifically the SHOW commands. SHOW is a command that displays information about
Multi Group_Concat in a single query with Distinct – MySQL
The CONCAT() function joins the input strings or different column values and returns as a single string. However, if we need to concatenate rows of
Big Data & SQL 