my aim is to be able to incriment student form each year
i.e form 1 next year to be form 2.i tried using \*\*mysql events \*\*but seem to be complicated for my situation.
i have the following tables

```
 id       student_id        form      year
----------
  1       2013-04-04888       1        2013
  2       2013-04-01920       2        2013

```

after **one year** i want to have something like this

```
id       student_id       form       year
----------
1       2013-04-04888       1        2013
2       2013-04-01920       2        2013
3       2013-04-04888       2        2014
4       2013-04-01920       3        2014

```

any one with the idea or suggestion on how i can do in this the proffesional way