Which mysql function is used to concatenate string?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to add a new column to an existing table in mysql?

755


What is blob storage?

701


Is mariadb better than mysql?

753


Is mysql relational?

704


What is mysql port?

753


How do you create a primary key?

701


What does schema mean?

664


What is striped backup

2017


How to enter Characters as HEX Numbers?

754


What is save point in mysql?

709


What is the difference between char and varchar in mysql?

729


What is a select query?

651


What are the different column comparison operators in mysql?

682


What is data type for image in mysql?

656


What is the difference between timestamp and datetime in mysql?

749