1 row in set (0.00 sec)
?
四、测试
1．主库执行
mysql> use test
Database changed
mysql> create table tt(id int,namevarchar(20));
Query OK, 0 rows affected (0.00 sec)
?
mysql> insert into tt values(1,'jhp');
Query OK, 1 row affected (0.00 sec)
?
2．在从库中检查是否同步过来：
mysql> select * from test.tt;
+------+------+
| id | name |
+------+------+
| 1 | jhp |
+------+------+
1 row in set (0.00 sec)