有人可以解释以下SQL查询的作用吗？

I have my suspicions but I want to independently verify, what does this query do? It's for a mybb forum database:

我怀疑但我想独立验证,这个查询有什么作用?这是一个mybb论坛数据库:

SHOW COLUMNS FROM mybb_users LIKE 'unreadpms'

For clarification, I'm asking if this is a query to view all users' unread PMs (the suspicious part)? I know it seems 'Captain Obvious' but I'm attempting to "independently verify" "my suspicions".

为了澄清,我问这是否是查询所有用户未读PM(可疑部分)的查询?我知道它似乎是“明显上尉”,但我试图“独立验证”“我的怀疑”。

1 个解决方案

#1

As the semantics of the code suggest, it shows columns from a table.

正如代码的语义所示,它显示了表中的列。

From the documentation, an example would be:

从文档中,一个例子是:

mysql> SHOW COLUMNS FROM City;
+------------+----------+------+-----+---------+----------------+
| Field      | Type     | Null | Key | Default | Extra          |
+------------+----------+------+-----+---------+----------------+
| Id         | int(11)  | NO   | PRI | NULL    | auto_increment |
| Name       | char(35) | NO   |     |         |                |
| Country    | char(3)  | NO   | UNI |         |                |
| District   | char(20) | YES  | MUL |         |                |
| Population | int(11)  | NO   |     | 0       |                |
+------------+----------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

Whatever columns are in mybb_users which match the filter LIKE 'unreadpms' would be returned in a similar format.

mybb_users中哪些列匹配过滤器LIKE'unreadpms'将以类似的格式返回。

#1