Converting mssql trigger in mysql
<p>i just moved from mssql to mysql and what i'm doing now is converting all my triggers in mssql to mysql and i'm finding difficulites. I'm inserting a record
into a table called <code>pp_change</code> and when that is done a table called <code>profile</code> should be updated and lastly insert the record in a <code>photo</code> table</p>

<pre><code>DELIMITER $$

CREATE TRIGGER pic_pic AFTER INSERT ON pp_change
FOR EACH ROW
BEGIN      

BEGIN             
    UPDATE profile           
    SET  profile_pix = pp_change.pic           
    FROM Inserted pp_change          
   WHERE profile.email = pp_change.email          

INSERT INTO photos (email,pic,wardrobe,upload_type,pic_view,up_user_id,country,time_group,fpage)                            

SELECT (email,pic,wardrobe,upload_type,pic_view,user_id,country,time_group,fpage) 
from pp_change             

END$$
DELIMITER ;
</code></pre>

<p>When i execute i get this error</p>

<pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM Inserted pp_change 
</code></pre>