create trigger update_before_video_info before update
on video_info for each row
begin
insert into video_info_update(action_name, id, name, alias_name, episode_num, publish_country_id, length, language, publish_date, score, search_code, modified_time, modifier, sort_by) values('update_before',new.id,new.name,new.alias_name,new.episode_num,new.publish_country_id,new.length,new.language,new.publish_date,new.score,new.search_code,new.modified_time,new.modifier,new.sort_by);
end
mysql -- 触发器 更新前
最新推荐文章于 2022-01-21 14:56:40 发布