alancoleman/output_serial_number_in_sql.sql

Last active December 25, 2015 04:09

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

Download ZIP

Output an incremented serial number as part of a select statement

Raw

output_serial_number_in_sql.sql

	SET @serial=0;
	SELECT @serial := @serial+1 AS `serial_number`

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