You have a MySQL instance with the following variables in the /etc/my.cnf file:
在/etc/my.cnf文件中有一个MySQL实例，其中包含以下变量：

You issue these statements:
你的问题是:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose one.)
在排除语句一个小时后，您意识到自己犯了一个错误，并且想要转到二进制日志并再次查看语句。
哪个论述是对的？（选一个。）
A. You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
您将收到该语句的错误，因为您无法更新使用USE语句指定的其他数据库。
B. The changes caused by the UPDATE statement are logged to the binary log because the instance is using —binlog-format = ROW
由UPDATE语句引起的更改被记录到二进制日志中，因为实例使用的是—binlog-format = ROW
C. The statement would fail because you cannot update more than one row at a time when using –binlogformat = ROW.
该语句将失败，因为使用–binlogformat = ROW时一次不能更新多行。
D. Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the —binlog-format value set to STATEMENT.
没有记录任何内容，因为您正在执行UPDATE语句，该语句将导致对多行的更改，并且您未将—binlog-format值设置为STATEMENT。
E. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
没有将任何内容写入二进制日志，因为如果不将语句用单引号引起来，就无法在查询中执行计算。
Answer:Dhttp://www.cndba.cn/hbhe0316/article/22803

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL