How to make changes to the database?

Question

MySQL

There is a project on Symfony. In one table, you need to change the field value in accordance with the values ​​​​in the file (for example, csv). The file has an Id and a Name field. Those. on Id I find record and I replace Name.
The question is how to run it all in production. So far I have come to the decision to issue this task as a console command ( Console Commands ), pull these changes with a git, and execute?
But it bugs me that it's somehow easier to do.

Answer 1

All right. Your task is solved with the help of a console command that you need to write.
This approach will give you the opportunity to execute a command for at least 100 hours (let's imagine that you have a lot of data in a csv file)