Interested to Buy Any Domain ? << Click Here >> for more details...
Which mysql function is used to concatenate string?
- 1 Answers
- 1548 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
Does mysql use tcp or udp?
What is localhost in mysql?
What are the other commands to know the structure of a table using mysql commands except explain command?
What is triggers and how it can be used in mysql?
What is the default port for mysql and how it can change?
What is a left join mysql?
How can we find out which auto increment was assigned on Last insert?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
What is new mysqli?
How can we get total number of records by query in mysql?
what is the difference between between and in operators in mysql?
Write a command to list all databases in mysql?
What does do in mysql?
How to show all tables with 'mysql'?
How to calculate the difference between two time values?
