A user executes the statement;
PURGE BINARY LOGS TO ‘mysql-bin.010’;
What is the result?
A.
It deletes all binary log files, except ‘mysql-in.010’.
B.
It deletes all binary log files up to and including ‘mysql-bin.010’.
C.
It deletes all binary log files before ‘mysql-bin.010’.
D.
It deletes all binary log files after ‘mysql-bin.010’.
Explanation:
Reference: http://dev.mysql.com/doc/refman/5.5/en/purge-binary-logs.html
C
I agree C
The PURGE BINARY LOGS statement deletes all the binary log files listed in the log index file prior to the specified log file name
C
c
http://dev.mysql.com/doc/refman/5.6/en/purge-binary-logs.html
C