Number records with incrementing ID (add an ID column to an existing table)

Revision: 11262

at January 29, 2009 12:13 by hlubek

Initial Code

SET @id := 0;
UPDATE users SET id = (@id := @id + 1) WHERE id = 0;

Initial URL

Initial Description

Initial Title

Number records with incrementing ID (add an ID column to an existing table)

Initial Tags

Initial Language

MySQL