A concatenation is the combining of two or more columns, expressions, or literal strings to display combined data in one column. The MySQL function for concatenation is
CONCAT. For example:
CONCAT( expression_1, ‘ ‘, expression_2 ) where expression_1 and expression_2 are either column names, expressions, or literal strings separated by a delimiter. In this case, it is a space.
SELECT CONCAT(fname,' ',lname) AS 'Name' FROM person;
The values from the fname and lname columns display together in one column of output with ‘Name’ as a column heading which is the literal string.[table “” not found /]