每年更新Mysql中的列

Question

I would like to update few columns in my database every year. I am using PHP and MYSQL.

How to update/reset the columns to specific values every year ?

I have heard that we use it with the Time stamp.

I have searched a lot about it .. nothing found.

Can someone help me ?

Thanks in Advance :)

EDIT 1 :

I am making an election system for my DBMS project.

This is how my table looks like

student table in database

I would like to refresh the register_Check and C_reg_no columns every year !!

Answer 1

Ideally you would restructure your database to handle different values for different years.

Move those columns into another table and a column for year and another as a foreign key field to link the registration info to the user info. Then you can keep track of the values for each year.