Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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