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 add a new column to an existing table in mysql?
What is blob storage?
Is mariadb better than mysql?
Is mysql relational?
What is mysql port?
How do you create a primary key?
What does schema mean?
What is striped backup
How to enter Characters as HEX Numbers?
What is save point in mysql?
What is the difference between char and varchar in mysql?
What is a select query?
What are the different column comparison operators in mysql?
What is data type for image in mysql?
What is the difference between timestamp and datetime in mysql?