title: MYSQL Update Trigger get updated row ID
body: <p>I have a table in MySQL which I am updating. I would like the trigger to get the updated row ID so as to do some work with it. How can I do it? I can do this in SQL Server, but I am new to MySQL and couldn't find anything online.</p>
  
  <p>UPDATE...</p>
  
  <p>So I can't share the code, but this is basically want I want to do.</p>
  
  <pre><code>Table: 
  **id** **product** **price**
  1,     Coke,         2.05 USD 
  2,     Sprite,       2.00 USD
  3,     7Up,          2.10 USD
  </code></pre>
  
  <p>I want to update id 2, "Sprite" price to 2.50 USD. Now I will do this normally, but I need to run a Trigger that will update an Audit table. The Audit table will need to register the id of the product. So basically I need to know that the updated row's id was 2... </p>
  
  <p>is there anything similar in sql?</p>