reset master;

use test;

drop table if exists t1;

create table t1(id int not null primary key,first varchar(32), last varchar(32), age int) engine=innodb;

insert into t1 values(100, 'Zara', 'Ali', 18);

insert into t1 values(101, 'Mahnaz', 'Fatma', 25);

insert into t1 values(102, 'Zaid', 'Khan', 30);

insert into t1 values(103, 'Sumit', 'Mittal', 28);

select id, first, last, age from t1;

id first last age

100 Zara Ali 18

101 Mahnaz Fatma 25

102 Zaid Khan 30

103 Sumit Mittal 28

select id, age, UPPER(first) as name from update t1 set age=age+30 where id in(100, 101);

id age name

100 48 ZARA

101 55 MAHNAZ

select id, first, last, age from t1;

id first last age

100 Zara Ali 48

101 Mahnaz Fatma 55

102 Zaid Khan 30

103 Sumit Mittal 28

show binlog events in 'master-bin.000001' from 120;

Log_name Pos Event_type Server_id End_log_pos Info

master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */

master-bin.000001 # Query # # use `test`; create table t1(id int not null primary key,first varchar(32), last varchar(32), age int) engine=innodb

master-bin.000001 # Query # # BEGIN

master-bin.000001 # Query # # use `test`; insert into t1 values(100, 'Zara', 'Ali', 18)

master-bin.000001 # Xid # # COMMIT /* XID */

master-bin.000001 # Query # # BEGIN

master-bin.000001 # Query # # use `test`; insert into t1 values(101, 'Mahnaz', 'Fatma', 25)

master-bin.000001 # Xid # # COMMIT /* XID */

master-bin.000001 # Query # # BEGIN

master-bin.000001 # Query # # use `test`; insert into t1 values(102, 'Zaid', 'Khan', 30)

master-bin.000001 # Xid # # COMMIT /* XID */

master-bin.000001 # Query # # BEGIN

master-bin.000001 # Query # # use `test`; insert into t1 values(103, 'Sumit', 'Mittal', 28)

master-bin.000001 # Xid # # COMMIT /* XID */

master-bin.000001 # Query # # BEGIN

master-bin.000001 # Query # # use `test`; update t1 set age=age+30 where id in(100, 101)

master-bin.000001 # Xid # # COMMIT /* XID */

drop table t1;