Skip to content

Instantly share code, notes, and snippets.

@prayas-sapkota

prayas-sapkota/serial-number.sql

Created September 7, 2016 11:50
Show Gist options
  • Save prayas-sapkota/d10ebe79a004ff95fe2ddf7c5448abc4 to your computer and use it in GitHub Desktop.
Save prayas-sapkota/d10ebe79a004ff95fe2ddf7c5448abc4 to your computer and use it in GitHub Desktop.
Download ZIP
Auto increment serial number in sql query.
Raw
serial-number.sql
SELECT @a:=@a+1 serial_number, student_name, student_class FROM TBL_STUDENT, (SELECT @a:= 0) AS a;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment