I want to create a trigger in mysql which insert a row in a table when update a row in another table
<p>I want to create a trigger in mysql which insert a row in a table change_history when there is any update in another table event_data if event_data.title='event_media'.</p>

<pre><code>DELIMITER $$
CREATE TRIGGER `after_evdata_update` 
AFTER UPDATE ON event_data
FOR EACH ROW
BEGIN
if OLD.title &lt;=&gt; 'event_media'
    INSERT INTO change_history (badge,city,country,venue,company,
date,rehosted,type,cancelled,name,tagline,description,agenda,pricing,
edition,photo_video,exhibitors,speakers,official_url,twitter_handle,
twitter_hashtag,facebook_url,contact,post_review_id) values(1,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null);
end if;
END $$
DELIMITER ;
</code></pre>