The following MySQL query can be used to view multiple tables’ row counts in one single SELECT statement. CREATE TABLE Dept( EmployeeDetails VARCHAR(100)); INSERT INTO
GROUP_CONCAT in MySQL
GROUP_CONCAT() is a function that merges the data from multiple rows into one field. It is a GROUP BY function that returns a string. The
REGEXP in MySQL
A regular expression is a powerful way of specifying a pattern for a complex search. It performs a pattern match of a string expression against
UPDATE with CASE in MySQL
The CASE expression checks each condition and, if the first one is true, returns a value. It will therefore stop reading and return the outcome
RAW Data for normalization practice
Data organization in a database is done by normalization. This entails creating tables and linking those tables together in accordance with principles intended to safeguard
Usage of TIME datatype in MySQL
When retrieving and displaying TIME data, MySQL uses the format ‘hh:mm:ss’ (or ‘hhh:mm:ss’ for huge hours values). ‘-838:59:59’ to ‘838:59:59’ are the possible TIME values.
Big Data and SQL 