Which mysql function is used to concatenate string?



Which mysql function is used to concatenate string?..

Answer / hrindows@gmail.com

CONCAT() function is used to combine two or more string data. The use of this function is here with an example.
Example: The following SELECT query with CONCAT() function will combine five words, ‘Welcome ‘, ‘to’, ‘SoftwareTestingHelp’,’.’ and ‘com’.

SELECT CONCAT('Welcome ',to ','SoftwareTestingHelp','.',com');

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do we use % when performing a search query?

0 Answers  


What is MySQL Stored Procedure?

1 Answers  


How do I run mysql?

0 Answers  


Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 Answers  


How do you start MySQL on Linux?

3 Answers  


Give the syntax of GRANT commands?

3 Answers  


what is the querry for all managers salary?

2 Answers  


What is the use of procedure in mysql?

0 Answers  


How many types of indexes are there in mysql?

0 Answers  


How do I stop a mysql service?

0 Answers  


How to include character strings in sql statements?

0 Answers  


What is dbms in mysql?

0 Answers  


Categories