jeudi 7 janvier 2016

Create 10 different random numbers

I want generate some random data. ~50k rows

Every row have ID autonumeric and 10 numeric values from 1 to 90.

+----+------+------+------+------+------+------+------+------+------+------+
| id | nr1  | nr2  | nr3  | nr4  | nr5  | nr6  | nr7  | nr8  | nr9  | nr10 |
+----+------+------+------+------+------+------+------+------+------+------+
| 1  | 1    | 39   | 19   | 23   | 28   | 80   | 3    | 42   | 60   | 32   |
+----+------+------+------+------+------+------+------+------+------+------+
| 2  | 43   | 18   | 3    | 24   | 29   | 33   | 15   | 1    | 61   | 80   |
+----+------+------+------+------+------+------+------+------+------+------+
| 3  | 11   | 25   | 33   | 2    | 30   | 3    | 1    | 44   | 62   | 78   |
+----+------+------+------+------+------+------+------+------+------+------+

So each row need to have 10 different values.

I could generate 10 random numbers but compare all 10 between them self to make sure there isn't duplicates values take a lot of time.




Aucun commentaire:

Enregistrer un commentaire