Hi there
I have a database with entries like the following:
Id, Name, Goals_season, Goals_total
----------------------------------------
5, John, 5, 23
6, Mike, 2, 14
7, Joe, 10, 34
Every season we have to reset the "Goals_season" column to the default value
(0), but not the other columns...
What is the easiest way to do this? Should I simply delete the column and
create a new column, or...?
(I hope my question isn't to stupid - it's been a year since I worked with
mysql)
Best regards
JL