Talend Data Migration Tool

Start from Creating a Project see screen below

Create job now

From the component choose Databases and Mysql
Then Drag tMysqlInput and Drop in job design area.
Click on it and enter mysql connection in Component section and write query for the data which you want to dump into target database.

Then Drag tMysqlOutput and Drop in job design area.
Click on it and enter mysql connection in Component section.

From the component choose Processing and Drag tMap and Drop in job design area.
Then Map tMysqlInput to tMap and tMap to tMysqlOutput
To map you have to right click on tMysqlInput->row->main  then right click on tMap->row->Newoutput

Now double click on Map new mapping screen will open where you have to drag column from left to right side.
left one is your source table and right one is your target table.
see screen

Now go and run your created job that's it.
see screen

Read More »

MySQL Using SUM and CASE in statement

Problems i faced in mysql query

one day i was working on Race project where director can payment online and manually .
I had been stored all Amount in one column "amt".
take a look on below image

I was want SUM of manual payment , electronic payment and total of all payment in one query.  That day i had been write following query by using Mysql SUM() function and conditional CASE statement.
Here we need to use conditional CASE statement within a SUM() That's it.
And the query is

SELECT  SUM(CASE WHEN `pay_type`="manual" THEN `amt` ELSE 0 END) AS manual_amt,SUM(CASE WHEN `pay_type`="electronic" THEN `amt` ELSE 0 END) AS electronic_amt,SUM(`amt`) AS total_amt FROM pay

In cakephp you can sum like below
 $condition = array('fields' => array('Message.read_status AS read_status','SUM(CASE WHEN read_status=0 THEN \'1\' ELSE \'0\' END) AS MsgCnt'));

Perhaps it can happen with you so use my query and enjoy! .

Read More »