return LAST_INSERT_ID()

Anonymous — Tue, 14 Feb 2017 07:12:05 GMT

Hi,

Please help: I have a tMysqlRow component with an insert statement inside it. Now my goal is, after that statement, I want to return the LAST_INSERT_ID() of the row inserted by that statement. Ho do I do this using the same component?

I am trying to add a "SELECT LAST_INSERT_ID();" after that insert statement (multi-query) but nothing happens.

Please help.

Thanks!

Re: return LAST_INSERT_ID()

Anonymous — Wed, 15 Feb 2017 07:46:26 GMT

Hi,
Here is a component TalendHelpCenter:tMysqlLastInsertId which is used to fetch the last inserted ID from a selected MySQL Connection.
Best regards
Sabrina

topic return LAST_INSERT_ID() in Talend Studio

return LAST_INSERT_ID()

Re: return LAST_INSERT_ID()