Advanced Search

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

/ Published in: MySQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SET @id := 0;
  2. UPDATE users SET id = (@id := @id + 1) WHERE id = 0;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.