lundi 16 décembre 2019

How can I random seed a MySQL column?

The column in my database contains 4 statuses:

  • 0-Active
  • 1-Awaiting User input
  • 2-Archive In Progress
  • 3-Excluded From Archival

I need to go through the column and randomly change things that are not marked as 0 to some random picking of the other 3 statuses.

What would be the best way for me to go about this? It was requested I use a Python script with random seed so that the state could be recreated. Does anyone have thoughts?




Aucun commentaire:

Enregistrer un commentaire