title: auto update field in table using phpmyadmin
body: <p>I have 2 tables . Order table with unique order_id and status field. And the order_line table have one or more row for each order_id in the order table and each row have status field.
  The task is to update the order table status field for an order_id with a new value when all status field in the order_line table for a particular oder_id is updated with a particular value.</p>
  <p>How can be this done Using mysql trigger functionality</p>
  <p>order table
  <img src="https://i.stack.imgur.com/yPH95.png" alt="order table" /></p>
  <p>order_line table
  <img src="https://i.stack.imgur.com/qK6So.png" alt="order_line table" /></p>