20 Jun
2013
20 Jun
'13
12:51 p.m.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9921 --- Comment #38 from M. de Rooy <m.de.rooy@rijksmuseum.nl> --- Nuno, I came across this SQL construct. It makes the use of a exclusive row level lock not needed: UPDATE tablename SET counter = LAST_INSERT_ID( counter + 1) WHERE id=xxx SELECT LAST_INSERT_ID(); The second select does not need table access anymore. So you really make it one call. Concurrent use is covered nicely. -- You are receiving this mail because: You are watching all bug changes.