Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Random test data generation Devstronomy
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