我执行执行了mysql>insertintokvalues(5,6);showbinlogeventsin'mysql_bin.000020';+------------------+-----+----------------+-----------+-------------+--------------------|Lo...
我执行执行了
mysql> insert into k values(5,6);
show binlog events in 'mysql_bin.000020';
+------------------+-----+----------------+-----------+-------------+--------------------
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+------------------+-----+----------------+-----------+-------------+--------------------
| mysql_bin.000020 | 4 | Format_desc | 110 | 123 | Server ver: 5.7.21-log, Binlog ver: 4 |
| mysql_bin.000020 | 123 | Previous_gtids | 110 | 154 | |
| mysql_bin.000020 | 154 | Anonymous_Gtid | 110 | 219 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS' |
| mysql_bin.000020 | 219 | Query | 110 | 291 | BEGIN |
| mysql_bin.000020 | 291 | Table_map | 110 | 336 | table_id: 108 (test.k) |
| mysql_bin.000020 | 336 | Write_rows | 110 | 380 | table_id: 108 flags: STMT_END_F |
| mysql_bin.000020 | 380 | Xid | 110 | 411 | COMMIT /* xid=26 */ |
+------------------+-----+----------------+-----------+-------------+--------------------
根本看不到insert的sql语句,网上的 show binlog events 中info中都能看到insert的具体执行语句,请问我这怎么都不行呢?我的版本是mysql 5.7.21。跟版本有关?
展开