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 | +--------------------------------------------+ 

## 28.4.5.8 The list_drop() Function 

Removes a value from a comma-separated list of values and returns the result. For more information, see the description of list_add() 

## Parameters 

## Return Value 

## 28.4.5.9 The ps_is_account_enabled() Function 

• in_list TEXT : The list to be modified. 

• in_drop_value TEXT : The value to drop from the list. 

A TEXT  value. 

Returns YES  or NO  to indicate whether Performance Schema instrumentation for a given account is enabled. 

## Parameters 

## Return Value 

## Example 

• in_host VARCHAR(60) : The host name of the account to check. 

• in_user VARCHAR(32) : The user name of the account to check. 

An ENUM(’YES’,’NO’)  value. 

mysql> SELECT sys.ps_is_account_enabled(’localhost’, ’root’); +------------------------------------------------+ | sys.ps_is_account_enabled(’localhost’, ’root’) | +------------------------------------------------+ | YES | +------------------------------------------------+ 

