title: mysql how to get the last inserted row values in a trigger
body: <p>I am writing a trigger after insert event on a table. This is the table</p>
  
  <pre><code>    CREATE TABLE `orderitem` (
         `orderItemId` INT(11) NOT NULL AUTO_INCREMENT,
         `orderItemQuantity` INT(11) NULL DEFAULT NULL,
         `stockId` INT(11) NULL DEFAULT NULL,
         `rate` DOUBLE NULL DEFAULT NULL,
         `orderId` INT(11) NULL DEFAULT NULL,
         PRIMARY KEY (`orderItemId`)
      )
  </code></pre>
  
  <p>Inside the trigger I need the values inserted for the current row(not only the id) inside the trigger. In T-SQL we can use the inserted table but in MySQL I could not find anything like that. How can I get those values?
  Thanks in advance.</p>