https://community.qlik.com/t5/Talend-Studio/tMysqlLastInsertId-returns-the-FIRST-inserted-ID/m-p/2348083#M115252 Hello, <BR />I can anyone tell me what happens here? I have to insert some rows in a MySQL table, then to retrieve the last inserted ID. The insertion is correctly executed, but tMysqlLastInsertId returns not the LAST, but the FIRST inserted ID !! I can't believe it! This happens either if I commit the insertion or without committing them, please advise! <BR /> <BR />Thank you. <BR /> <BR />PS <BR />Working on TOS Version: 3.1.3/ Build id: r26090-20090629-1316t Sat, 16 Nov 2024 13:42:41 GMT Anonymous 2024-11-16T13:42:41Z https://community.qlik.com/t5/Talend-Studio/tMysqlLastInsertId-returns-the-FIRST-inserted-ID/m-p/2348083#M115252 Hello, <BR />I can anyone tell me what happens here? I have to insert some rows in a MySQL table, then to retrieve the last inserted ID. The insertion is correctly executed, but tMysqlLastInsertId returns not the LAST, but the FIRST inserted ID !! I can't believe it! This happens either if I commit the insertion or without committing them, please advise! <BR /> <BR />Thank you. <BR /> <BR />PS <BR />Working on TOS Version: 3.1.3/ Build id: r26090-20090629-1316t Sat, 16 Nov 2024 13:42:41 GMT https://community.qlik.com/t5/Talend-Studio/tMysqlLastInsertId-returns-the-FIRST-inserted-ID/m-p/2348083#M115252 Anonymous 2024-11-16T13:42:41Z https://community.qlik.com/t5/Talend-Studio/tMysqlLastInsertId-returns-the-FIRST-inserted-ID/m-p/2348084#M115253 Hello <BR />Change a little in your job: <BR />... <BR /> | <BR />onsubjobok <BR /> | <BR />tMysqlLastInsertID---tLogRow---tMysqlCommit. <BR /> <BR />Best regards <BR /> <BR /> shong Fri, 30 Oct 2009 08:58:29 GMT https://community.qlik.com/t5/Talend-Studio/tMysqlLastInsertId-returns-the-FIRST-inserted-ID/m-p/2348084#M115253 Anonymous 2009-10-30T08:58:29Z