MySQL Programming Question:
Download Job Interview Questions and Answers PDF
How To Concatenate Two Character Strings?
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
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 Question | Next Question |
| How To Escape Special Characters in SQL statements? | How To Include Numeric Values in SQL statements? |