concat

Description

Syntax

‘VARCHAR concat (VARCHAR,…)’

Connect multiple strings and return NULL if any of the parameters is NULL

example

  1. mysql> select concat("a", "b");
  2. +------------------+
  3. *124concat ('a','b') 1244;
  4. +------------------+
  5. 1.2.2.2.2.2.
  6. +------------------+
  8. mysql> select concat("a", "b", "c");
  9. +-----------------------+
  10. 124concat ('a','b','c') 1244;
  11. +-----------------------+
  12. 1.2.2.2.2.2.2.
  13. +-----------------------+
  15. mysql > select concat ("a", null, "c");
  16. +------------------------+
  17. 124concat (a), NULL,'c')
  18. +------------------------+
  19. No. No. No.
  20. +------------------------+

keyword CONCAT