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
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
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.
MySQL UPDATE with Incremental value
When you wish to UPDATE a specific column with an incremental value or UPDATE the column with a string and incremental integers, the following methods
Big Data & SQL 