Submitted by admin on Tue, 2014/10/21 - 15:40
This short tutorial was inspired by a question I had from a customer. They were trying to insert rows into a "log" table at the beginning of a job and update that same row at the end of the job. The problem was that they were using an auto generated primary key in a MySQL database. This in itself isn't a bad thing to do, in fact it could be argued that it is the right thing to do (control sequences/ids at the database end), but they could not work out how to get hold of that generated "id" without running the risk of another job interacting with the table causing errors.