EVENT_OBJECT_TABLE: account ACTION_ORDER: 1 ACTION_CONDITION: NULL ACTION_STATEMENT: SET @sum = @sum + NEW.amount ACTION_ORIENTATION: ROW ACTION_TIMING: BEFORE ACTION_REFERENCE_OLD_TABLE: NULL ACTION_REFERENCE_NEW_TABLE: NULL ACTION_REFERENCE_OLD_ROW: OLD ACTION_REFERENCE_NEW_ROW: NEW CREATED: 2018-08-08 10:10:12.61 SQL_MODE: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION DEFINER: me@localhost CHARACTER_SET_CLIENT: utf8mb4 COLLATION_CONNECTION: utf8mb4_0900_ai_ci DATABASE_COLLATION: utf8mb4_0900_ai_ci 

Trigger information is also available from the SHOW TRIGGERS  statement. See Section 13.7.7.40, “SHOW TRIGGERS Statement” . 

## 26.3.46 The INFORMATION_SCHEMA USER_ATTRIBUTES Table 

The USER_ATTRIBUTES  table (available as of MySQL 8.0.21) provides information about user comments and user attributes. It takes its values from the mysql.user  system table. 

The USER_ATTRIBUTES  table has these columns: 

• USER 

The user name portion of the account to which the ATTRIBUTE  column value applies. 

• HOST 

The host name portion of the account to which the ATTRIBUTE  column value applies. 

• ATTRIBUTE 

The user comment, user attribute, or both belonging to the account specified by the USER  and HOST columns. The value is in JSON object notation. Attributes are shown exactly as set using a CREATE USER ... ATTRIBUTE ...  or ALTER USER ... ATTRIBUTE ...  statement. The user comment is shown as a key-value pair having comment  as the key. 

For example, the statement CREATE USER ’bill’@’localhost’ COMMENT ’A comment’ ATTRIBUTE ’{"foo": "bar", "bazz": "fazz"}’  adds the following row to the USER_ATTRIBUTES  table: 

+------+-----------+--------------------------------------------------------+ | USER | HOST | ATTRIBUTE | +------+-----------+--------------------------------------------------------+ | bill | localhost | {"foo": "bar", "bazz": "fazz", "comment": "A comment"} | +------+-----------+--------------------------------------------------------+ 

## Notes 

• USER_ATTRIBUTES  is a nonstandard INFORMATION_SCHEMA  table. 

•To obtain only the user comment for a given user as an unquoted string, you can employ a query such as this one: 

