mercredi 15 mai 2019

MySQL Select 1000 records randomly when Primary key is a string

I have a table with 200k records and I want to have 1000 rows randomly to work on.

The primary key is something like this

000279a4-3214-4f9c-93c3-168634f4548a

I saw this question but PK is a number in there, so does not work for me

MySQL select 10 random rows from 600K rows fast




Aucun commentaire:

Enregistrer un commentaire