dimanche 8 janvier 2017

MySQL Mix data in table

I need to mix data in MySQL table. I explain how.

ORIGINAL TABLE:
  ______________________________
  id | name   | color | country
   1 | James  | Gray  | USA
   2 | Marry  | Blue  | UK
   3 | Andrew | Green | AU

RANDOMLY MIXED TABLE:
  ______________________________
  id | name   | color | country
   2 | Andrew | Gray  | UK
   1 | Marry  | Green | AU
   3 | James  | Blue  | USA

But I need it to be dynamic (work with 2, 3, 10 or more columns without changing code too much and hardcoding names). It can also use PHP, but pure MySQL solution is better.




Aucun commentaire:

Enregistrer un commentaire