不好意思啊!主数据库的记录数少于次数据库,共同的变量 是stock.合并后的结果: +----------------------------------------------------+
| stock area soe fin style _merge |
|----------------------------------------------------|
1221. | 002723 19 0 1 1 matched (3) |
1230. | 200002 19 1 1 1 matched (3) |
1242. | 200024 19 1 1 1 matched (3) |
1247. | 200030 7 0 1 1 matched (3) |
1248. | 200037 19 1 1 1 matched (3) |
|----------------------------------------------------|
1253. | 200054 22 1 1 1 matched (3) |
1254. | 200055 19 0 1 1 matched (3) |
1255. | 200056 19 0 1 1 matched (3) |
1256. | 200057 19 0 1 1 matched (3) |
1257. | 200058 19 1 1 1 matched (3) |
次数据库的记录是:
+----------------+
| stock style |
|----------------|
1221. | 002717 1 |
1230. | 002727 1 |
1242. | 002739 1 |
1247. | 002745 1 |
1248. | 002746 1 |
|----------------|
1253. | 200002 1 |
1254. | 200003 1 |
1255. | 200011 1 |
1256. | 200012 1 |
1257. | 200013 1 |
|----------------|
1258. | 200015 1 |
1259. | 200016 1 |
1260. | 200017 1 |
1261. | 200018 1 |
1262. | 200019 1 |
|----------------|
1263. | 200020 1 |
1264. | 200022 1 |
1265. | 200024 1 |
1266. | 200025 1 |
1267. | 200026 1
合并后的style和次数据库中的style不匹配啊,为什么,谢谢