Re: Need to swap primary keys - does mysql have a way?

[Peter Brawley]

There's not a native swap function. Find the first missing sequence number with

SELECT
a.pk + 1 AS 'Missing From',
MIN(b.pk) - 1 AS 'To'
FROM tbl AS a, tbl AS b
WHERE a.pk < b.pk
GROUP BY a.pk
HAVING a.pk < MIN(b.pk) - 1
ORDER BY a.pk+1 LIMIT 1;

PB