MySQL Programming Interview Question:

How To Concatenate Two Character Strings?

Submitted by: Administrator

If you want concatenate multiple character strings into one, you need to use the CONCAT() function. Here are some good examples:

SELECT CONCAT('Welcome',' to') FROM DUAL;
Welcome to

SELECT CONCAT('ggl','center','.com') FROM DUAL;
GlobalGuideLine.com

Submitted by: Administrator