Common Mysql Query

Here are the list of some commonly used mysql queries and their result...

1. SELECT  EXTRACT(YEAR_MONTH FROM NOW() - INTERVAL 2 MONTH )

Output: 201506

you can also add any useful mysql query in this post's comment section.

Increase tOracleInput data read speed

I was reading the data from distant server and getting the speed 70row/sec and the data set was huge like 7,00,000. With that speed it was too difficult to run the job quickly.

Then I got the solution.

 I just used the cursor option, and now I am getting 4000+ row/second speed.