title: create trigger to update some column after update specific column in same table
body: <p>I have a table called BrrowedBookBy 
  <a href="https://i.stack.imgur.com/7vTsQ.png" rel="nofollow noreferrer">here is the table description</a></p>
  
  <pre><code>+--------------------+-------------+------+-----+---------+-------+
  | Field              | Type        | Null | Key | Default | Extra |
  +--------------------+-------------+------+-----+---------+-------+
  | ISBN_B             | char(50)    | YES  |     | NULL    |       |
  | PIN_M              | int(11)     | YES  |     | NULL    |       |
  | StartDate          | date        | YES  |     | NULL    |       |
  | EndDate            | date        | YES  |     | NULL    |       |
  | BrrowBookCondition | tinyint(1)  | YES  |     | NULL    |       |
  | Late               | tinyint(1)  | YES  |     | NULL    |       |
  | ReNew              | tinyint(1)  | YES  |     | NULL    |       |
  | Fine               | int(11)     | YES  |     | NULL    |       |
  | Fine_Description   | varchar(30) | YES  |     | NULL    |       |
  +--------------------+-------------+------+-----+---------+-------+
  9 rows in set (0.040 sec)
  </code></pre>
  
  <p>so I want to set trigger on updating the BorrowBookCondition Column </p>
  
  <p>I tried as this but not working in Maria</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` TRIGGER Set_fine
    AFTER Update ON BorrowedBookBy
     FOR EACH ROW
      UPDATE Fine SET Fine = 50 and fine_description = “Not Meet The Condition”
        where BrrowBookCondition in (select * from BorrowedBookBy where BrrowBookCondition =0);
  </code></pre>
  
  <p>If I type it as this without any condition it's working just fine</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` TRIGGER Set_fine
    AFTER Update ON BorrowedBookBy
     FOR EACH ROW
      UPDATE Fine SET Fine = 50 and fine_description = “Not Meet The Condition”;
  </code></pre>