weird-coon/auto_increase.sql

Created June 19, 2020 03:51

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

Download ZIP

Generate auto increment field in select query

Raw

auto_increase.sql

	SELECT @n := @n + 1 n,
	first_name,
	last_name
	FROM table1, (SELECT @n := 0) m
	ORDER BY user_id

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