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 many values can the SET function of MySQL take?
2 Answers Creative Informatics,
Explain Normalization concept?
How do I know if mysql is installed on windows?
What is the difference between database and table?
How do I change mysql password?
How many TRIGGERS are allowed in MySql table?
How do I connect to a database in mysql workbench?
Is mysql free software?
How do I rename a table in mysql?
What are all the Common SQL Function?
List the different types of normalization?
How to delete a database from mysql server.
Oracle (3253)
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)