Im not much of a mysql whiz so I need some help here. And yes I have googled and got an idea of how to do it, just asking here if someone can assist in my particular situation.
I have a table called videos. Each row has 3 columns I need to change. the current value is 0 so i need to update it to correct values.
the columns are
I need them updated from 0 to
So again the table is videos and want to update the values of the columns listed from 0 to the values I posted. there is over 7k tables so cant really do it manually.