title: How can I create a Job or event in mysql
body: <p>I would like to create a job in <code>mysql</code> which runs on the end of the day, where in that job I would like to update some of the column values in my tables. Assume I am having 2 tables where I am having a column named <code>Status</code> which is either <code>Pending or Accepted</code>. For this I would like to create a Job where I would like to search the two tables and set <code>Pending</code> status to <code>Accepted</code>.</p>
  
  <p>Is it possible to have</p>