从小例子开始-2-输入、输出
2017-07-05 本文已影响0人
cure_py
表输入--SQL语句
![](https://img.haomeiwen.com/i5757611/ec01fed2737d3559.png)
![](https://img.haomeiwen.com/i5757611/15ddfa00ce125548.png)
![](https://img.haomeiwen.com/i5757611/71c9465a8ab837e2.png)
自己加入mysql语句
![](https://img.haomeiwen.com/i5757611/d666b6a0ed6f1fd4.png)
用位置参数的情况
![](https://img.haomeiwen.com/i5757611/65b6bca030d6f2e2.png)
这里是个 ?
![](https://img.haomeiwen.com/i5757611/439fd889da81aeee.png)
![](https://img.haomeiwen.com/i5757611/b3b6ac3422be222f.png)
稍微复杂一点
![](https://img.haomeiwen.com/i5757611/2510ba4592e6ef3d.png)
![](https://img.haomeiwen.com/i5757611/d9e1647a8692df5f.png)
![](https://img.haomeiwen.com/i5757611/d623122f2752bb23.png)
表输出
![](https://img.haomeiwen.com/i5757611/4f4ccaa52ec69faa.png)
![](https://img.haomeiwen.com/i5757611/42175142a4b9d076.png)
分区输入--但需要先自行创建表
![](https://img.haomeiwen.com/i5757611/77b4aeef649d9ed7.png)
![](https://img.haomeiwen.com/i5757611/59e8f0f0358113e5.png)
映射
![](https://img.haomeiwen.com/i5757611/a463fb4c0de3444d.png)
错误处理
![](https://img.haomeiwen.com/i5757611/ff04dd9d5b34bf4c.png)
![](https://img.haomeiwen.com/i5757611/014fef3704d37c61.png)
![](https://img.haomeiwen.com/i5757611/001f3eca302a2078.png)
可以run
![](https://img.haomeiwen.com/i5757611/23f8a9e60ae17f32.png)
删除
更新和删除差不多
插入/更新类似,但是插入效率慢
![](https://img.haomeiwen.com/i5757611/e25e733b5fcb2c9d.png)
合并比较
![](https://img.haomeiwen.com/i5757611/49cbe831c9b34fc1.png)
基于数据比较的同步
![](https://img.haomeiwen.com/i5757611/6b6ac3ee110ba2c0.png)
![](https://img.haomeiwen.com/i5757611/383648365a62436b.png)
自己加入mysql语句
用位置参数的情况
这里是个 ?
稍微复杂一点
分区输入--但需要先自行创建表
映射
可以run
删除
更新和删除差不多
插入/更新类似,但是插入效率慢