Skip to content

Instantly share code, notes, and snippets.

@indiejoseph

indiejoseph/increment_number.sql

Created May 16, 2014 03:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save indiejoseph/d71c199c96ea76bc86db to your computer and use it in GitHub Desktop.
Save indiejoseph/d71c199c96ea76bc86db to your computer and use it in GitHub Desktop.
Download ZIP
Increment number in MySQL
Raw
increment_number.sql
SELECT
`chars`.`id`,
@n := @n +1 AS `index`
FROM
`characters` AS `chars`,
(SELECT @n := -1) AS `m`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment