我在转换一个表中的多个值时遇到了一个奇怪的问题。在
我有一个table
的数据,如下所示:
+-------------+--------------+-------------+
| id | name | category_id |
+=============+==============+=============+
| 1 | Horse | 5 |
+-------------+--------------+-------------+
| 2 | Cow | 5 |
+-------------+--------------+-------------+
| 3 | Pig | 2 |
+-------------+--------------+-------------+
| 4 | Chicken | 3 |
+-------------+--------------+-------------+
然后我通过category_id
找到:
然后我像这样循环数据,这样我就可以将上面的category_id转换为目标category id:
^{3}$我似乎只知道:
+-------------+--------------+-----------------------------+
| id | name | category_id |
+=============+==============+=============================+
| 1 | Horse | 5 |
+-------------+--------------+-----------------------------+
| 2 | Cow | 5 |
+-------------+--------------+-----------------------------+
| 3 | Pig | 2 |
+-------------+--------------+-----------------------------+
| 4 | Chicken | QnicP3f4njL54HRqu |
+-------------+--------------+-----------------------------+
当它应该是的时候
+-------------+--------------+-----------------------------+
| id | name | category_id |
+=============+==============+=============================+
| 1 | Horse | 5 |
+-------------+--------------+-----------------------------+
| 2 | Cow | 5 |
+-------------+--------------+-----------------------------+
| 3 | Pig | yrDku5Yqkc2MKZZkD |
+-------------+--------------+-----------------------------+
| 4 | Chicken | QnicP3f4njL54HRqu |
+-------------+--------------+-----------------------------+
有什么建议吗?在
etl.convert()
创建一个新表,每次迭代都来自同一个未更改的源table
。因此,每个结果中只更改一行。更改代码如下:现在你总是在研究最后的结果。在
相关问题 更多 >
编程相关推荐