mysql> update pet set sex='m' where name='hunter';

　　Query OK, 1 row affected (0.00 sec)

　　Rows matched: 1 Changed: 1 Warnings: 0

　　mysql> delete from pet where name='hunter';

　　Query OK, 1 row affected (0.00 sec)

　　[mysql@test2]$ mysqlbinlog log-bin.000002

　　/*!40019 SET @@session.max_insert_delayed_threads=0*/;

　　/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;

　　# at 4

　　#080313 7:52:47 server id 1 end_log_pos 98 Start: binlog v 4, server v 5.0.26-standard-log created 080313 7:52:47

　　# Warning: this binlog was not closed properly. Most probably mysqld crashed writing it.

　　# at 98

　　#080313 10:06:26 server id 1 end_log_pos 229 Query thread_id=18 exec_time=0 error_code=0

　　use test;

　　SET TIMESTAMP=1205373986;

　　SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;

　　SET @@session.sql_mode=0;

　　/*!\C latin1 */;

　　SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;

　　insert into pet values('hunter','yxyup','cat','f','1996-04-29',null);

　　# at 229

　　#080313 10:07:13 server id 1 end_log_pos 334 Query thread_id=18 exec_time=0 error_code=0

　　SET TIMESTAMP=1205374033;

　　update pet set sex='m' where name='hunter';

　　# at 334

　　#080313 10:07:38 server id 1 end_log_pos 432 Query thread_id=18 exec_time=0 error_code=0

　　SET TIMESTAMP=1205374058;

　　delete from pet where name='hunter';

　　# at 432

　　#080313 10:14:13 server id 1 end_log_pos 532 Query thread_id=18 exec_time=0 error_code=0

　　SET TIMESTAMP=1205374453;

　　create table t1(id int,name char(10));

　　# at 532

　　#080313 10:14:41 server id 1 end_log_pos 625 Query thread_id=18 exec_time=0 error_code=0

　　SET TIMESTAMP=1205374481;

　　alter table t1 add sex char(2);

　　# End of log file

　　ROLLBACK /* added by mysqlbinlog */;

　　/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

　　[mysql@test2]$

　　可以看出，三条DML操作和两条DDL都记录到了binlog中了，而select并没有记录。