Which mysql function is used to concatenate string?
- 1 Answers
- 1090 Views
- I also Faced
- E-Mail Answers
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
Where is mysql data stored?
What is mysql enterprise edition?
What are the benefits of mysql?
What are the advantages/disadvantages of mysql and php?
What is the maximum connection pool size?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
How do you backup a database in mysql?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
How to dump one database for backup.
How to get the number of rows selected or affected by a sql statement?
How do I create a stored procedure in mysql?
How to create a table?
How to enter binary numbers in sql statements?
What does mysql_fetch_assoc do?
