Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

26.4.5.7 The list_add() Function

Adds a value to a comma-separated list of values and returns the result.

This function andlist_drop() can be useful for manipulating the value of system variables such assql_mode andoptimizer_switch that take a comma-separated list of values.

Parameters

  • in_list TEXT: The list to be modified.

  • in_add_value TEXT: The value to add to the list.

Return Value

ATEXT value.

Example
mysql> SELECT @@sql_mode;+----------------------------------------+| @@sql_mode                             |+----------------------------------------+| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES |+----------------------------------------+mysql> SET @@sql_mode = sys.list_add(@@sql_mode, 'NO_ENGINE_SUBSTITUTION');mysql> SELECT @@sql_mode;+---------------------------------------------------------------+| @@sql_mode                                                    |+---------------------------------------------------------------+| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |+---------------------------------------------------------------+mysql> SET @@sql_mode = sys.list_drop(@@sql_mode, 'ONLY_FULL_GROUP_BY');mysql> SELECT @@sql_mode;+--------------------------------------------+| @@sql_mode                                 |+--------------------------------------------+| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |+--------------------------------------------+