Which mysql function is used to concatenate string?
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 |
How do we use % when performing a search query?
What is MySQL Stored Procedure?
How do I run mysql?
Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows
How do you start MySQL on Linux?
Give the syntax of GRANT commands?
what is the querry for all managers salary?
What is the use of procedure in mysql?
How many types of indexes are there in mysql?
How do I stop a mysql service?
How to include character strings in sql statements?
What is dbms in mysql?