Hi, I try to use the tMysqlLastInsertId componant but I don't understand how to use it. Description of the job I've made: - Read a spreadsheet file - Insert data into database - Log id of inserted data You can see a screenshot of my job in attachment. The problem is that the autogenerated "Last_insert_id" column contains always the value "0" instead of the value of autoincrement. Does anyone know how can I get the value of autoincrement ? Thx in advance for your help.
How can I get the id for each row ? It is possible ?
Yes, we can get all the new inserted id. There is a global variable can be used to get the first new inserted id:
tMysqlOutput_1_NB_LINE: the total number of new inserted rows.
For more information, please see my screenshots.
Best regards
shong
Hi, first you seem to have an error on your tMySQLOutput component (see red cross). Despite this, in the db table, make sure your id is set to autoincrement.
Long-time lurker, first-time poster... I'm having the same issue with virtually the same setup, though I don't have any compile problems in my job. In my tMySqlLastInsertId_1 component, I have tMySqlConnection_1 in my "Link with" field and I'm using a built-in schema. Any advice on this would be extremely helpful.
Hello shong,
I try to reproduce your example.
See my screenshot.
I've just replace the tRowGenerator componant by a tFileInputExcel.
When I run the job, I see 2 problems:
- I have value 0 instead of null for last_insert_id column in console.
- If you look at the statistics, 20 rows have been inserted into database.
But only one row is displayed in console for last_insert_id...
Do you know why ?
Thx for your help.
Hi shong,
I've uploaded 2 screenshots:
- structure of my table (view from phpmyadmin)
- configuration of tMysqlOutput component (which insert value in my database)
You can see that my table has an autoincrement column as primary key.
Hi shong,
I update my job and found what it doesn't work:
I must check option "use an existing connection" in the tMysqlOutput component
and select the good tMysqlConnection in drop down list.
So it works !
I get a not null last inserted id when I execute the job.
But if the job insert more than one row in my table, I only get the inserted id for the last row.
How can I get the id for each row ?
It is possible ?
