Auto Update Record Modify Time with MySql Trigger

Following code can be used to define trigger

DROP TRIGGER IF EXISTS `short_urlModifiedUpdate`//
CREATE TRIGGER `short_urlModifiedUpdate` BEFORE UPDATE ON `short_url`
 FOR EACH ROW BEGIN
    SET NEW.modified = NOW();
END