title: how to change the remaining annual leave column value to default at the beginning of each year?
body: <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">Id</th>
  <th style="text-align: center;">Name</th>
  <th style="text-align: center;">residual</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">Ruri</td>
  <td style="text-align: center;">12</td>
  </tr>
  <tr>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">Trala</td>
  <td style="text-align: center;">10</td>
  </tr>
  <tr>
  <td style="text-align: center;">3</td>
  <td style="text-align: center;">Suki</td>
  <td style="text-align: center;">4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><em>This is a table of the remaining annual leave of employees</em>.</p>
  <p>in this table every employee takes leave, then the remaining column of annual leave will <em>automatically decrease</em> according to the annual leave taken.</p>
  <p>The weakness of this table is that at the beginning of each year, the remaining annual leave column must be <em>updated manually to return the default value</em> of 12.</p>
  <p>is there a way in the MariaDB database to <em>automatically return the default values</em> ​​at the beginning of each year? and how?</p>