MySQL Programming Question:

Download Job Interview Questions and Answers PDF

How To Concatenate Two Character Strings?

MySQL Programming Interview Question
MySQL Programming Interview Question

Answer:

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


Download MySQL Programming Interview Questions And Answers PDF

Previous QuestionNext Question
How To Escape Special Characters in SQL statements?How To Include Numeric Values in SQL statements?