I want to reset a column of the table after a month I have a table e.g T1



I want to reset all rows where status = 0 and store these data (where status=0) in another table T2, but I want to do this after a month.
Kindly suggest what to do.

I am doing this in FEE Management system where a student will pay fee once in a month and after a month status should be "0" because I will use this table again for the next month. and i want to copy all data where status=1 in another table before reset the status column.
Try using a transaction,

BEGIN;
  INSERT INTO t2
    SELECT *
    FROM t1
    WHERE status=0
    FOR UPDATE;

  DELETE FROM t1
    WHERE status=0;

COMMIT;