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

Is mysql still popular?

490


What is difference between pdo and mysqli?

465


how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

1804


What is longblob?

539


What is meant by mysqli?

495






How do I show users in mysql?

511


How much does mysql cost?

477


Where is the mysql database stored?

477


What is a trigger? How you can create a trigger in mysql?

483


What is delimiter in mysql stored procedure?

477


How do I save in mysql?

486


How do I clear a mysql database?

513


How to change the database engine in mysql?

448


How do I clear the command in mysql?

493


How to delete a trigger in mysql?

485