{"id":3125,"date":"2012-06-09T11:00:02","date_gmt":"2012-06-09T03:00:02","guid":{"rendered":"http:\/\/jpuyy.com\/?p=3125"},"modified":"2012-09-25T20:43:58","modified_gmt":"2012-09-25T12:43:58","slug":"mysql-procedure","status":"publish","type":"post","link":"https:\/\/jpuyy.com\/?p=3125","title":{"rendered":"mysql\u5b58\u50a8\u8fc7\u7a0b\u5b66\u4e60"},"content":{"rendered":"<p>\u4e00.\u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b<br \/>\n1.\u57fa\u672c\u8bed\u6cd5\uff1a<br \/>\ncreate procedure sp_name()<br \/>\nbegin<br \/>\n&#8230;&#8230;&#8230;<br \/>\nend<br \/>\n2.\u53c2\u6570\u4f20\u9012<br \/>\n\u4e8c.\u8c03\u7528\u5b58\u50a8\u8fc7\u7a0b<br \/>\n1.\u57fa\u672c\u8bed\u6cd5\uff1acall sp_name()<br \/>\n\u6ce8\u610f\uff1a\u5b58\u50a8\u8fc7\u7a0b\u540d\u79f0\u540e\u9762\u5fc5\u987b\u52a0\u62ec\u53f7\uff0c\u54ea\u6015\u8be5\u5b58\u50a8\u8fc7\u7a0b\u6ca1\u6709\u53c2\u6570\u4f20\u9012<br \/>\n\u4e09.\u5220\u9664\u5b58\u50a8\u8fc7\u7a0b<br \/>\n1.\u57fa\u672c\u8bed\u6cd5\uff1a<br \/>\ndrop procedure sp_name\/\/<br \/>\n2.\u6ce8\u610f\u4e8b\u9879<br \/>\n(1)\u4e0d\u80fd\u5728\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u4e2d\u5220\u9664\u53e6\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\uff0c\u53ea\u80fd\u8c03\u7528\u53e6\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b<br \/>\n\u56db.\u533a\u5757\uff0c\u6761\u4ef6\uff0c\u5faa\u73af<br \/>\n1.\u533a\u5757\u5b9a\u4e49\uff0c\u5e38\u7528<br \/>\nbegin<br \/>\n&#8230;&#8230;<br \/>\nend;<br \/>\n\u4e5f\u53ef\u4ee5\u7ed9\u533a\u5757\u8d77\u522b\u540d\uff0c\u5982\uff1a<br \/>\nlable:begin<br \/>\n&#8230;&#8230;&#8230;..<br \/>\nend lable;<br \/>\n\u53ef\u4ee5\u7528leave lable;\u8df3\u51fa\u533a\u5757\uff0c\u6267\u884c\u533a\u5757\u4ee5\u540e\u7684\u4ee3\u7801<br \/>\n2.\u6761\u4ef6\u8bed\u53e5<br \/>\nif \u6761\u4ef6 then<br \/>\nstatement<br \/>\nelse<br \/>\nstatement<br \/>\nend if;<\/p>\n<p>3.\u5faa\u73af\u8bed\u53e5<br \/>\n(1).while\u5faa\u73af<br \/>\n[label:] WHILE expression DO<\/p>\n<p>statements<\/p>\n<p>END WHILE [label] ;<br \/>\n(2).loop\u5faa\u73af<br \/>\n[label:] LOOP<\/p>\n<p>statements<\/p>\n<p>END LOOP [label];<\/p>\n<p>(3).repeat until\u5faa\u73af<br \/>\n[label:] REPEAT<\/p>\n<p>statements<\/p>\n<p>UNTIL expression<\/p>\n<p>END REPEAT [label] ;<\/p>\n<p>\u4e94.\u5176\u4ed6\u5e38\u7528\u547d\u4ee4<br \/>\n1.show procedure status<br \/>\n\u663e\u793a\u6570\u636e\u5e93\u4e2d\u6240\u6709\u5b58\u50a8\u7684\u5b58\u50a8\u8fc7\u7a0b\u57fa\u672c\u4fe1\u606f\uff0c\u5305\u62ec\u6240\u5c5e\u6570\u636e\u5e93\uff0c\u5b58\u50a8\u8fc7\u7a0b\u540d\u79f0\uff0c\u521b\u5efa\u65f6\u95f4\u7b49<br \/>\n2.show create procedure sp_name<br \/>\n\u663e\u793a\u67d0\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u7684\u8be6\u7ec6\u4fe1\u606f<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00.\u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b 1.\u57fa\u672c\u8bed\u6cd5\uff1a create procedure sp_name() begin &#8230;&#8230;&#8230; end 2.\u53c2\u6570\u4f20\u9012 \u4e8c.\u8c03\u7528\u5b58\u50a8\u8fc7\u7a0b 1.\u57fa\u672c\u8bed\u6cd5\uff1acall sp_name() \u6ce8\u610f\uff1a\u5b58\u50a8\u8fc7\u7a0b\u540d\u79f0\u540e\u9762\u5fc5\u987b\u52a0\u62ec\u53f7\uff0c\u54ea\u6015\u8be5\u5b58\u50a8\u8fc7\u7a0b\u6ca1\u6709\u53c2\u6570\u4f20\u9012 \u4e09.\u5220\u9664\u5b58\u50a8\u8fc7\u7a0b 1.\u57fa\u672c\u8bed\u6cd5\uff1a drop procedure sp_name\/\/ 2.\u6ce8\u610f\u4e8b\u9879 (1)\u4e0d\u80fd\u5728\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u4e2d\u5220\u9664\u53e6\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\uff0c\u53ea\u80fd\u8c03\u7528\u53e6\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b \u56db.\u533a\u5757\uff0c\u6761\u4ef6\uff0c\u5faa\u73af 1.\u533a\u5757\u5b9a\u4e49\uff0c\u5e38\u7528 begin &#8230;&#8230; end; \u4e5f\u53ef\u4ee5\u7ed9\u533a\u5757\u8d77\u522b\u540d\uff0c\u5982\uff1a lable:begin &#8230;&#8230;&#8230;.. end lable; \u53ef\u4ee5\u7528leave lable;\u8df3\u51fa\u533a\u5757\uff0c\u6267\u884c\u533a\u5757\u4ee5\u540e\u7684\u4ee3\u7801 2.\u6761\u4ef6\u8bed\u53e5 if \u6761\u4ef6 then statement else statement end if; 3.\u5faa\u73af\u8bed\u53e5 (1).while\u5faa\u73af [label:] WHILE expression DO statements END WHILE [label] ; (2).loop\u5faa\u73af [label:] LOOP [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-3125","post","type-post","status-publish","format-standard","hentry","category-life"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/3125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3125"}],"version-history":[{"count":3,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/3125\/revisions"}],"predecessor-version":[{"id":3659,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/3125\/revisions\/3659"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}