Pre-General Availability Draft: 2018-02-20
COLUMN_PRIVILEGES table provides
information about column privileges. This information comes from
mysql.columns_priv grant table.
In the output from
SHOW FULL COLUMNS, the privileges are all in one field and in lowercase, for example,
COLUMN_PRIVILEGES, there is one privilege per row, in uppercase.
The following statements are not equivalent:
SELECT ... FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES SHOW GRANTS ...