--source include/master-slave.inc set names 'gbk'; create table test.test(id int, name varchar(50)) charset gbk; delimiter //; create procedure pload() BEGIN declare j int default 1; while j<=2 do insert into test(id,name) values(j,concat('中华人民共和国', j)); set j=j+1; end while; end; // delimiter ;// call pload(); show binlog events; --sync_slave_with_master --vertical_results show slave status;