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 many columns can a mysql table have?
In which language mysql has been written?
how to connect a php script with the mysql database?
How to copy data from one server to another using php?
What is the command line end user interface - mysql?
What is mysql data directory? How to determine the location of the data directory?
What is mysql command line?
What is a query in mysql?
What command is used to delete the data from the table without deleting the table structure?
What does mysql flush tables do?
What is the difference between char and varchar?
Why do we use preparedstatement?
What does mysql_query return?
Where is mysql data stored linux?
Does mysql use sql?