Working with databases is constantly associated with obtaining query results. And in some cases, this information must be displayed in a certain way or combined with other data. To solve this problem, there is an SQL function - CONCAT.
What does the CONCAT function do?
When performing some work with databases, there is a need to connect rows with additional data or with each other. To solve this problem, there is an SQL function - CONCAT. When used, two or more lines will be combined into one. In this case, the string concatenation operation will be correctly performed both when working with strings and with numerical variables.
SQL CONCAT . , MySQL – CONCAT_WS. : , , NULL, NULL, .
CONCAT, SQL- , . : CONCAT , , , AS , . CONCAT :
CONCAT (1, 2 [, 3, ...]) [AS _].
, , , . , SQL CONCAT. , .
CONCAT?
, CONCAT, SQL . "+", , .
"+" , , , . , "6":
SELECT 1+2+3.
.