Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

return LAST_INSERT_ID()

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!

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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