Question

Explain concat function.

Answer 1

The CONCAT function can have any number of arguments and it returns a string that is the result of concatenating the arguments.

Ex. > SELECT CONCAT ('I', 'Iove','MySQL')

I Love MySQL

SELECT CONCAT ('I', 'NULL, 'MySQL') NULL