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 I install mysql on windows 10?
What are the differences between mysql vs sql server?
Difference between CHAR and VARCHAR?
What is mysql_query?
What is the limitation of mysql?
How many entries can mysql handle?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
How to delete the repeated records from a table?
How can we run batch mode in mysql?
How can I create table in mysql?
How internally data stores in MyISAM and INNODB table types?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)