--source include/master-slave.inc

set names gbk;

set binlog_format='row';

CREATE TABLE `za` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_code` varchar(255) DEFAULT NULL COMMENT '订单号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk ;

create table test.zb AS 
select 
id 订单日,
order_code 卖家NICK
from test.za;

--sync_slave_with_master
--vertical_results
show slave status;