16 lines
493 B
Plaintext
16 lines
493 B
Plaintext
DROP TABLE IF EXISTS t1;
|
|
RESET MASTER;
|
|
CREATE TABLE t1 (a INT);
|
|
SET AUTOCOMMIT=OFF;
|
|
BEGIN;
|
|
INSERT INTO t1 VALUES(1);
|
|
DROP TABLE t1;;
|
|
COMMIT;
|
|
include/show_binlog_events.inc
|
|
Log_name Pos Event_type Server_id End_log_pos Info
|
|
binlog.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
|
|
binlog.000001 # Query # # BEGIN
|
|
binlog.000001 # Query # # use `test`; INSERT INTO t1 VALUES(1)
|
|
binlog.000001 # Query # # COMMIT
|
|
binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
|