title: MySQL Trigger on after insert
body: <p>I am new to MySQL. I have two tables <code>total_loaner</code> and <code>available_loaner</code>. I am trying to create a trigger for every new row added in <code>total_loaner</code>, I would also like to add that new row to <code>available_loaner</code>.</p>
  <p>Here how my tables look like:</p>
  <pre><code>CREATE TABLE `total_loaner` (
    `Kind` varchar(10) NOT NULL,
    `Type` varchar(10) NOT NULL,
    `Sno` varchar(10) NOT NULL,
    PRIMARY KEY (`Sno`)
  )
  
  CREATE TABLE `available_loaner` (
    `Kind` varchar(10) NOT NULL,
    `Type` varchar(10) NOT NULL,
    `Sno` varchar(10) NOT NULL,
    `Status` char(10) NOT NULL DEFAULT '',
    PRIMARY KEY (`Sno`)
  ) 
  </code></pre>
  <p>My trigger does not seem to work.</p>
  <pre><code>CREATE TRIGGER new_loaner_added 
  AFTER INSERT ON 'total_loaner' for each row
  begin
  INSERT INTO available_loaner (Kind, Type, Sno, Status)
  Values (new.Kind, new.Type, new.Sno, 'Available');
  END;
  </code></pre>