glafarge/reorder.sql

Created August 22, 2016 13:31

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/glafarge/17fc33f0ce1ae5765f3a8b7812389558.js"></script>
Save glafarge/17fc33f0ce1ae5765f3a8b7812389558 to your computer and use it in GitHub Desktop.

Download ZIP

Reincrement field of a MySQL table

Raw

reorder.sql

	SET @pos := 0;
	UPDATE table SET position = ( SELECT @pos := @pos + 1 ) ORDER BY id ASC;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment