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
Is mysql free for commercial use?
How to update info already in a table and delete a row(s) from a table.
How to dump a table to a file with 'mysqldump'?
What is normalization and list the different types of normalization?
How to get the number of rows selected or affected by a sql statement?
Is mysql workbench a dbms?
Is pdo more secure than mysqli?
How to declare variable in mysql trigger?
What is indexing in mysql?
What is mysqlcommand?
What is mysql gpl?
What is MySQL?
What is mysql data directory? How to determine the location of the data directory?
What is mysqli_select_db?
Why we use mysqli instead of mysql?