Skip to content

Instantly share code, notes, and snippets.

@kovid-r

kovid-r/devstronomy_generate_random_test_data.sql

Last active May 18, 2020 11:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kovid-r/d52f5694cf9f21195b9c9c3b470dae78 to your computer and use it in GitHub Desktop.
Save kovid-r/d52f5694cf9f21195b9c9c3b470dae78 to your computer and use it in GitHub Desktop.
Download ZIP
Random test data generation Devstronomy
Raw
devstronomy_generate_random_test_data.sql
select distinct *
from (select *
from devstronomy.l_satellite
where rand() < .5
union all
select *
from devstronomy.l_satellite
where rand() > .5
) t
order by rand()
limit 100
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment