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
How to show table structure mysql?
State the differences between mongodb and mysql.
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
What is difference between oracle and mysql?
Is mysql a server or database?
What is the size of mysql database?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
What is data directory in mysql?
How do I assign a variable in mysql?
How do I zip a file in mysql?
Which command is used to view the content of the table in mysql?
What is memory table?
In which language mysql has been written?
What is the purpose of -> in the mysql terminal?
How do I remove a user from mysql?