MySQL Trigger on after insert

MySQL Trigger on after insert

I am new to MySQL. I have two tables total_loaner and available_loaner. I
am trying to create a trigger for every new row added in total_loaner, I
would to add that new row to available_loaner.
Here how my tables look like: 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) )
My trigger does not seem to work. 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;