[Koha-bugs] [Bug 9921] Make it possible to force 001 = biblionumber

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9921

--- Comment #38 from M. de Rooy <m.de.rooy at 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.