- 论坛徽章:
- 0
|
配置我发到附件里了。下面贴操作过程。
切分规则,id < 5 读77,id between 5 and 10 读78。
192.168.8.77安装了amoeba和mysql
192.168.8.78安装了mysql
77上的表数据:
mysql> select * from t1;
+------+------+
| id | name |
+------+------+
| 1 | a |
| 2 | b |
| 3 | c |
| 4 | d |
| 5 | e |
| 6 | f |
| 7 | g |
| 8 | h |
| 9 | i |
| 10 | j |
| 11 | k |
+------+------+
11 rows in set (0.00 sec)
mysql> select * from t2;
+------+------+
| id | name |
+------+------+
| 1 | a1 |
| 2 | a2 |
| 3 | a3 |
| 4 | a4 |
| 5 | a5 |
| 6 | a6 |
| 7 | a7 |
| 8 | a8 |
| 9 | a9 |
| 10 | a10 |
+------+------+
10 rows in set (0.00 sec)
78上的表数据
mysql> select * from t1;
+------+------+
| id | name |
+------+------+
| 1 | aa |
| 2 | bb |
| 3 | cc |
| 4 | dd |
| 5 | ee |
| 6 | ff |
| 7 | gg |
| 8 | hh |
| 9 | ii |
| 10 | jj |
| 11 | k |
+------+------+
11 rows in set (0.00 sec)
mysql> select * from t2;
+------+------+
| id | name |
+------+------+
| 1 | b1 |
| 2 | b2 |
| 3 | b3 |
| 4 | b4 |
| 5 | b5 |
| 6 | b6 |
| 7 | b7 |
| 8 | b8 |
| 9 | b9 |
| 10 | b10 |
+------+------+
10 rows in set (0.00 sec)
mysql>
===================================================
切分规则,id < 5 读77,id between 5 and 10 读78。
操作一张表,没有问题,如下:
mysql> select * from t1 where id < 5;
+------+------+
| id | name |
+------+------+
| 1 | a |
| 2 | b |
| 3 | c |
| 4 | d |
+------+------+
4 rows in set (0.01 sec)
mysql> select * from t1 where id > 5;
+------+------+
| id | name |
+------+------+
| 6 | ff |
| 7 | gg |
| 8 | hh |
| 9 | ii |
| 10 | jj |
| 11 | k |
+------+------+
6 rows in set (0.00 sec)
mysql> select * from t2 where id < 5;
+------+------+
| id | name |
+------+------+
| 1 | a1 |
| 2 | a2 |
| 3 | a3 |
| 4 | a4 |
+------+------+
4 rows in set (0.00 sec)
mysql> select * from t2 where id > 5;
+------+------+
| id | name |
+------+------+
| 6 | b6 |
| 7 | b7 |
| 8 | b8 |
| 9 | b9 |
| 10 | b10 |
+------+------+
5 rows in set (0.00 sec)
mysql>
===============================================
但表连接查询时,出现问题,如下:
mysql> select * from t1,t2 where t1.id=t2.id and t1.id > 5;
+------+------+------+------+
| id | name | id | name |
+------+------+------+------+
| 6 | f | 6 | a6 |
| 7 | g | 7 | a7 |
| 8 | h | 8 | a8 |
| 9 | i | 9 | a9 |
| 10 | j | 10 | a10 |
| 6 | ff | 6 | b6 |
| 7 | gg | 7 | b7 |
| 8 | hh | 8 | b8 |
| 9 | ii | 9 | b9 |
| 10 | jj | 10 | b10 |
+------+------+------+------+
10 rows in set (0.01 sec)
mysql> select * from t1,t2 where t1.id=t2.id and t1.id < 5;
+------+------+------+------+
| id | name | id | name |
+------+------+------+------+
| 1 | a | 1 | a1 |
| 2 | b | 2 | a2 |
| 3 | c | 3 | a3 |
| 4 | d | 4 | a4 |
| 1 | aa | 1 | b1 |
| 2 | bb | 2 | b2 |
| 3 | cc | 3 | b3 |
| 4 | dd | 4 | b4 |
+------+------+------+------+
8 rows in set (0.00 sec)
mysql> select * from t1,t2 where t1.id=t2.id and t2.id < 5;
+------+------+------+------+
| id | name | id | name |
+------+------+------+------+
| 1 | a | 1 | a1 |
| 2 | b | 2 | a2 |
| 3 | c | 3 | a3 |
| 4 | d | 4 | a4 |
| 1 | aa | 1 | b1 |
| 2 | bb | 2 | b2 |
| 3 | cc | 3 | b3 |
| 4 | dd | 4 | b4 |
+------+------+------+------+
8 rows in set (0.00 sec)
mysql> select * from t1,t2 where t1.id=t2.id and t2.id > 5;
+------+------+------+------+
| id | name | id | name |
+------+------+------+------+
| 6 | f | 6 | a6 |
| 7 | g | 7 | a7 |
| 8 | h | 8 | a8 |
| 9 | i | 9 | a9 |
| 10 | j | 10 | a10 |
| 6 | ff | 6 | b6 |
| 7 | gg | 7 | b7 |
| 8 | hh | 8 | b8 |
| 9 | ii | 9 | b9 |
| 10 | jj | 10 | b10 |
+------+------+------+------+
10 rows in set (0.01 sec)
mysql>
数据出现重复。
有谁遇到过这个问题? |
|