When working with several RDBMSs, even minor changes in syntax can cause difficulties. This is the first in a series of postings about how to
Category: RDBMS
Adding multiple columns in a table – MySQL
When you engage with several RDBMSs, even a small amount of change in syntax can cause confusion. This is the first in a series of
Percona XtraBackup for MySQL
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.
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.
Big Data & SQL 