1: concat () function

1: the meaning of

Concatenate multiple strings into a single stringCopy the code

2: grammar

concat(str1, str2,...) The result is a string generated by the connection parameters, or null if any of the parameters are nullCopy the code

2: concat_ws() function

1: the meaning of

As with concat(), multiple strings are concatenated into a single string, but the ~ (concat_ws is concat with separator) can be specified once.Copy the code

2: grammar

concat_ws(separator, str1, str2, ...) Note: The first argument specifies the delimiter. Note that the delimiter cannot be null; if it is null, the result is null.Copy the code