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 to increment dates by 1 in mysql?
How can we find out which auto increment was assigned on Last insert?
How can I see connections in mysql?
How does mysql clustering work?
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
why we are join a tow table
Does mysql use t sql?
What is key in mysql?
What are the common mysql functions?
What is trigger in mysql with example?
How can you find out the version of the installed mysql?
Where the database is stored 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)