INFORMATION SCHEMA (also referred as system catalog) gives you access to database metadata and MySQL server information like the name of a database or table,
Category: MySQL
Add New Line in MySQL with Concat
We know what to retrieve when changing data into a different format or performing data analysis, but we may get stuck on how to access
MySQL Temporary Table With Constraints
Temporary tables with constraints and indexes can be created in MySQL. Constraints can be defined even if the temporary table is created without giving column
SQL-92 and SQL-89 Joins
SQL-92 and SQL-89 joins are supported by most RDBMSs, including Apache Impala. This article will explain how the syntax is written in both ways and
EMP and DEPT Datasets for MySQL
In several of the SQL Server and MySQL examples in my blogs, I used Oracle’s “EMP” and “DEPT” datasets. In other RDBMSs, creating such tables
Hive Metadata Queries
Metadata is a type of data that describes and provides information about other types of data, such as database objects. And Hive’s metastore maintains metadata
Big Data & SQL 