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 is mysql database stored?
What is the difference between mysql_connect and mysqli_connect?
Restore database (or database table) from backup.
What is blob datatype in mysql?
What do you need to connect php to mysql?
What is prepare statement in mysql?
How can you make a database as your current database?
How do I edit a trigger in mysql?
How do I copy an entire mysql database?
How to create table with same structure of student table in mysql?
How do you rename a procedure in mysql?
In mysql, what is the default storage engine?
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)