array()

array()

description

Syntax

ARRAY<T> array(T, ...)

construct an array with variadic elements and return it, T could be column or literal

example

  1. mysql> select array("1", 2, 1.1);
  2. +----------------------+
  3. | array('1', 2, '1.1') |
  4. +----------------------+
  5. | ['1', '2', '1.1']    |
  6. +----------------------+
  7. 1 row in set (0.00 sec)
  10. mysql> select array(null, 1);
  11. +----------------+
  12. | array(NULL, 1) |
  13. +----------------+
  14. | [NULL, 1]      |
  15. +----------------+
  16. 1 row in set (0.00 sec)
  18. mysql> select array(1, 2, 3);
  19. +----------------+
  20. | array(1, 2, 3) |
  21. +----------------+
  22. | [1, 2, 3]      |
  23. +----------------+
  24. 1 row in set (0.00 sec)
  26. mysql>  select array(qid, creationDate, null) from nested  limit 4;
  27. +------------------------------------+
  28. | array(`qid`, `creationDate`, NULL) |
  29. +------------------------------------+
  30. | [1000038, 20090616074056, NULL]    |
  31. | [1000069, 20090616075005, NULL]    |
  32. | [1000130, 20090616080918, NULL]    |
  33. | [1000145, 20090616081545, NULL]    |
  34. +------------------------------------+
  35. 4 rows in set (0.01 sec)

keywords

ARRAY,ARRAY,CONSTRUCTOR