How to use: CONCAT (str1,str2,...) returns the string that results from the connection parameter. If any one of the arguments is NULL&NBSP, the return value is null. Note: If all parameters are non-binary strings, the result is a non-binary string. If the argument contains any twos binary string, the result is a binary string. A numeric parameter is converted to an equal binary string format; To avoid this, you can use explicit types cast, for example: Select concat (CAST (Int_col as char) , char_col) MySQL concat function can connect one or more strings, such as Mysql> select concat (' ten '); +--------------+| Concat (' ten ') |+--------------+| 10 |+--------------+1 row in set (0.00 sec) mysql> select concat (' One ', ' n ', ' + '); +------------------------+| concat (' One ', ' a ', ' |+ ')------------------------+| 112233 |+------------------------+1 row in set (0.00 sec) MySQL concat function in the connection string, as long as one of them is null, it will return nullmysql> select Concat (' One ', ' n ', null), +------------------------+| concat (' One ', ' n ', null) |+------------------------ +| null |+------------------------+1 row in set (0.00 sec)
concat function in MySQL
