Parameters
| Name | Type | Mode |
|---|---|---|
| in_list | text | IN |
| in_add_value | text | IN |
Takes a list, and a value to add to the list, and returns the resulting list.
Useful for altering certain session variables, like sql_mode or optimizer_switch for instance.
in_list (TEXT): The comma separated list to add a value to
in_add_value (TEXT): The value to add to the input list
TEXT
mysql> select @@sql_mode; +———————————————————————————–+ | @@sql_mode | +———————————————————————————–+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +———————————————————————————–+ 1 row in set (0.00 sec)
mysql> set sql_mode = sys.list_add(@@sql_mode, ‘ANSI_QUOTES’); Query OK, 0 rows affected (0.06 sec)
mysql> select @@sql_mode; +———————————————————————————————–+ | @@sql_mode | +———————————————————————————————–+ | ANSI_QUOTES,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +———————————————————————————————–+ 1 row in set (0.00 sec)
| Name | Type | Mode |
|---|---|---|
| in_list | text | IN |
| in_add_value | text | IN |