Talend community forum / update a Mysql database

bouty26 · 2012-07-06 10:29:28

hi , i've connected a mysql database to magento webservice , and i created a nwe category , so magento generated a new ID ;

i wan't to transfere this new id to mySQL database , (the same base as the first) i mean to update the field , i don't know how to do that because whare i'm trying to transfere the new ID a new line is generated it means a new catagory .

what i want to do is to update ma mysql database .
you can find below the Image of ma job

[img]http://img15.hostingpics.net/pics/881946schema1.jpg[/img]

[img]http://img15.hostingpics.net/pics/303065schema2.jpg[/img]

pedro · 2012-07-06 11:33:18

Hi

Could you explain it in another way?

Code:

because whare i'm trying to transfere the new ID  a new line is generated it means a new catagory

Regards,
Pedro

bouty26 · 2012-07-06 11:45:36

ok , i'll try to be more clear : when i create a category in mysql database i fill all the fields except one "ID_CATEGORY_STORE " when i'm connected to the webservice a new category is created and the webservice generated a ID_CATEGORY_STORE . it's the return the response of the webservice .

i 've to transfert this ID to the database to fill the ID_CATEGORY_STORE field .
when i execute the shema below in the Mysqloutput there is an insert of a new category and not and update of the existing (i just have to add the id or fill the Id field )

i hope that is more clear . sorry for my english

bouty26 · 2012-07-09 09:24:52

hello ,
did you find any answer to my precedent post . i tried to be more clear about what i did.
thanks for your answer in advance

Announcement

Unanswered posts

#1 2012-07-06 10:29:28

update a Mysql database

#2 2012-07-06 11:33:18

Re: update a Mysql database

Code:

#3 2012-07-06 11:45:36

Re: update a Mysql database

#4 2012-07-09 09:24:52

Re: update a Mysql database

Board footer