mysql - 如何更改 MySQL 中的 SHOW GRANTS 标题？

Question

我有以下查询:

MySQL [Database]> show grants for "user"@"%";
+-----------------------------------------------------------------+
| Grants for user@%                                               |
+-----------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'user'@'%'                       |
+-----------------------------------------------------------------+
1 row in set (0.00 sec)

现在我要做的是更改 Grants for user@% 标题，但以下语句会引发错误:

show grants for "user"@"%" AS TEST;
show grants AS TEST for "user"@"%";
select * from (show grants AS Test for "user"@"%") as SUB;

我想以某种方式得到以下结果:

MySQL [Database]> show grants for "user"@"%" AS TEST;
+-----------------------------------------------------------------+
| TEST                                                            |
+-----------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'user'@'%'                       |
+-----------------------------------------------------------------+
1 row in set (0.00 sec)

我之所以要更改标题，是因为我正在使用的 PHP 框架正在将数据库查询转换为对象，而 Grants for user@% 将是对象变量/字段，需要打电话，很不方便。

Answer 1

如果您不喜欢 SHOW GRANTS 的结果标题，您可以从 INFORMATION_SCHEMA 中的表中拼凑信息:

• USER_PRIVILEGES
• SCHEMA_PRIVILEGES
• TABLE_PRIVILEGES
• COLUMN_PRIVILEGES

我将把它留作练习，让您编写 SQL 查询来执行此操作。