Skip to content

Instantly share code, notes, and snippets.

@dbolser-ebi

dbolser-ebi/some.sql

Created October 15, 2018 11:03
Show Gist options
  • Save dbolser-ebi/1f2372c0df26b647804332eaf66ef4f4 to your computer and use it in GitHub Desktop.
Save dbolser-ebi/1f2372c0df26b647804332eaf66ef4f4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
some.sql
SET @i=1;
SET @l=10000000;
SELECT * FROM seq_region INNER JOIN (SELECT @i, @i:=@i+@l AS x) AS der
ON length < @i
WHERE seq_region_id = 196420;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment