title: Can I set multiple columns to NULL in MySQL in bulk?
body: <p>I have a very large database and for testing, I want to set a certain amount of data to NULL. </p>
  
  <p>As an example, I have 57 columns across 3 tables, all of which need to be nullified. I can't delete the rows, I just need to know that if the row exists and there's no data in those fields, that everything still works.</p>
  
  <p>To clarify, all the data in those fields has been moved to anther table, and the old data was not wiped in the migration. To test my reports I need to know that the reports are pulling from the new location, not the old, since as new data is added, it will only go to the new location. Our plan is to generate each report from the old database, migrate, and then generate them again and compare. But to ensure that they are pulling from the right place, we want to wipe the old data so it doesn't provide a false positive.</p>
  
  <p>Is there a way for me to do this in bulk or should I resign myself to writing one comma separated SET statement after another?</p>