MySQL: CONCAT, CONCAT_WS & GROUP_CONCAT functions

Concatenation is the basic operation in MySql when we are working string columns. With respect to string concatenation, MySql provides three types of functions, CONCAT, CONCAT_WS and GROUP_CONCAT. CONCAT: Just Concatenate all provided argument values. mysql>SELECT CONCAT('I', 'Am', 'Software', 'Developer'); //Result: IAmSoftwareDeveloper CONCAT_WS: Stand for Concatenate with Separator and Concatenate all arguments using provided special …