Parameters
| Name | Type | Mode |
|---|---|---|
| in_list | text | IN |
| in_drop_value | text | IN |
Takes a list, and a value to attempt to remove from 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 drop a value from
in_drop_value (TEXT): The value to drop from the input list
TEXT
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)
mysql> set sql_mode = sys.list_drop(@@sql_mode, ‘ONLY_FULL_GROUP_BY’); Query OK, 0 rows affected (0.03 sec)
mysql> select @@sql_mode; +—————————————————————————-+ | @@sql_mode | +—————————————————————————-+ | ANSI_QUOTES,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_drop_value | text | IN |