pierot/sql rank

Created May 8, 2019 08:12

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/pierot/a6282eac19f95f5f68eeab32b9744235.js"></script>
Save pierot/a6282eac19f95f5f68eeab32b9744235 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

	SET @rank:=0;
	UPDATE users SET email = CONCAT('test+', @rank:=@rank+1, '@test.be') WHERE id > 3

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