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