{"id":89,"date":"2014-02-21T23:55:08","date_gmt":"2014-02-21T15:55:08","guid":{"rendered":"http:\/\/blog.cyszys.com\/?p=89"},"modified":"2014-02-22T00:03:43","modified_gmt":"2014-02-21T16:03:43","slug":"mysql%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b%e4%b8%80%e4%be%8b","status":"publish","type":"post","link":"http:\/\/blog.cyszys.com\/?p=89","title":{"rendered":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b"},"content":{"rendered":"<p>\u00a0<!--more--><\/p>\n<pre class=\"brush:sql\">\/*=========================================\n\/*\u521b\u5efa\u4e00\u4e2a\u540d\u5b57\u4e3atestinster15()\u7684\u7a0b\u5e8f \n\/*=========================================\ndelimiter $\ncreate PROCEDURE testinsert15()\n  BEGIN\n        DECLARE v_num int;\n        DECLARE V_MAX INT;\n        SET v_num=0;\n        SELECT MAX(PEOPLEID) INTO V_MAX FROM PEOPLE;\n        REPEAT\n                SET v_num = v_num + 1;\n                UPDATE PEOPLE SET LASTNAME = UUID();\n                UPDATE PEOPLE SET FIRSTNAME = UUID();\n        UNTIL v_num = V_MAX END REPEAT;\n    commit;\n  END\n$\ndelimiter<\/pre>\n<pre class=\"brush:sql\">\/*=========================================\n\/*\u521b\u5efa\u4e00\u4e2a\u540d\u5b57\u4e3atestinster150()\u7684\u7a0b\u5e8f \n\/*=========================================\ndelimiter $\ncreate PROCEDURE testinsert150()\n  BEGIN\n        DECLARE v_num int;\n        SET v_num=0;\n        REPEAT\n                SET v_num = v_num + 1;\n                insert into people (name,lastname,firstname) values (uuid(),uuid(),uuid());\n        UNTIL v_num > 1500001 END REPEAT;\n    commit;\n  END\n$<\/pre>\n<p>\u00a0<\/p>","protected":false},"excerpt":{"rendered":"<p>\u00a0<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[35,45],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts\/89"}],"collection":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=89"}],"version-history":[{"count":6,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts\/89\/revisions"}],"predecessor-version":[{"id":95,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=\/wp\/v2\/posts\/89\/revisions\/95"}],"wp:attachment":[{"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.cyszys.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}