Re: Generate random unique IDs

[Rick James]

CREATE TABLE foo (
seq INT UNSIGNED AUTO_INCREMENT NOT NULL,
id type-of-your-id
);

INSERT INTO foo (id)
SELECT id FROM your-table ORDER BY rand();

Now foo has distinct integers from 1..N mapped to your ids.
Take things from there to put them into your table, or just join the tables as needed.