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 |
What is delimiter in mysql?
How many sql ddl commands are supported by 'mysql'?
Can we store images in mysql database?
Give the syntax of GRANT commands?
Does mysql use tcp or udp?
How can we change the name and data type of a column of a table?
What is RMS Migrations
How to declare variable in mysql trigger?
What is longblob?
How to list or view all databases from the mysql server.
What is mysql uuid?
How can you export the table as an xml file in mysql?
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)