{"type":"rich","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/hit10231023/","blog_url":"https://hit.hateblo.jp/","blog_title":"Database JUNKY","height":"190","categories":["MySQL","Storedprocedure","storedfunction","\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3","\u30b9\u30c8\u30a2\u30c9\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3","\u30c8\u30ea\u30ac\u30fc","SQL","FOR EACH ROW"],"description":"\u4f7f\u3044\u307f\u3061\u306b\u3088\u3063\u3066\u306f\u3001\u3059\u3054\u304f\u4fbf\u5229\u306a\u30c8\u30ea\u30ac\u30fc\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002\u4f7f\u3044\u307f\u3061\u3068\u66f8\u3044\u305f\u306e\u306f\u3001\u306a\u3093\u3067\u3082\u304b\u3093\u3067\u3082\u30c8\u30ea\u30ac\u30fc\u306b\u3082\u308a\u3082\u308a\u3057\u3061\u3083\u3046\u3068\u5bfe\u8c61\u30c6\u30fc\u30d6\u30eb\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306b\u5f71\u97ff\u51fa\u3061\u3083\u3046\u3088\u3068\u3044\u3046\u4e71\u5c04\u72b6\u614b\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u306e\u3067\u6ce8\u610f\u3063\u3066\u611f\u3058\u3067\u3059 \u30c8\u30ea\u30ac\u30fc\u3068\u306f Trigger\uff08\u30c8\u30ea\u30ac\u30fc\uff09\u3068\u306f\u3001\u5bfe\u8c61\u30c6\u30fc\u30d6\u30eb\u306e\u5909\u66f4\uff08INSERT,UPDATE,DELETE\uff09\u30a4\u30d9\u30f3\u30c8\u306b\u3088\u3063\u3066\u3042\u3089\u304b\u3058\u3081\u8a2d\u5b9a\u3057\u305f\u51e6\u7406\u3092\u81ea\u52d5\u3067\u5b9f\u884c\u3059\u308b\u6a5f\u80fd\u3067\u3059\u306d\u3002\u3088\u3046\u306f\u3001A\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u3001INSERT / UPDATE / DELETE \u306e\u5f15\u304d\u91d1\uff08\u30c8\u30ea\u30ac\u30fc\uff09\u3092\u5f15\u3044\u305f\u3089\u3001B\u30c6\u30fc\u30d6\u30eb\u306e\u66f4\u65b0\u4ef6\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u30a2\u30c3\u30d7\u3059\u308b\u3068\u304b\u304c\u826f\u3044\u4f8b\u3067\u3059\u306d\u3002\u7c21\u5358\u306a\u4f8b\u3092\u66f8\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059","version":"1.0","published":"2018-01-11 18:51:50","width":"100%","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/h/hit10231023/20180309/20180309104332.jpg","author_name":"hit10231023","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhit.hateblo.jp%2Fentry%2FMYSQL%2FSQL%2FTRIGGER\" title=\"\u4e71\u5c04\u6ce8\u610f\uff01\uff01\uff01MySQL TRIGGER\uff08\u30c8\u30ea\u30ac\u30fc\uff09\u306f\u7d50\u69cb\u4f7f\u3048\u308b\uff01\uff01 - Database JUNKY\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://hit.hateblo.jp/entry/MYSQL/SQL/TRIGGER","title":"\u4e71\u5c04\u6ce8\u610f\uff01\uff01\uff01MySQL TRIGGER\uff08\u30c8\u30ea\u30ac\u30fc\uff09\u306f\u7d50\u69cb\u4f7f\u3048\u308b\uff01\uff01"}