On a master server that is using statement-based replication, a table of log data has become very large. You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)
A. Change the replication mode to mixed before issuing any delete statements when the limit clause is used.
B. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
C. Use the limit clause to limit the deletion to 100.000 rows.
D. Use the limit clause in conjunction with the order by clause.
Answer: AD
使用limit子句时，在发出任何delete语句之前将复制模式更改为混合模式。
将limit子句与order by 子句一起使用。http://www.cndba.cn/hbhe0316/article/22818http://www.cndba.cn/hbhe0316/article/22818

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

MYSQL