Loading lesson path
Concept visual
Start at both ends
SELECT CONCAT("SQL ", "Tutorial ", "is ", "fun!") AS ConcatenatedString;The CONCAT() function adds two or more expressions together.
CONCAT_WS() function.
expression1, expression2, expression3,...)
Description expression1, expression2, expression3, etc. Required. The expressions to add together.
If any of the expressions is a NULL value, it returns NULL
From MySQL 4.0
Add three columns into one "Address" column:
SELECT CONCAT(Address, " ", PostalCode, " ", City) AS AddressCustomers;❮ MySQL Functions