masayuki5160/rowNum.sql

Created September 12, 2013 06:17

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

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

Download ZIP

行番号をだすとき

Raw

SELECT @i:=@i+1 as rownum,`USER_ID` FROM (select @i:=0) as dummy,`USER_TBL`

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