{"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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\/*========================================= \/*\u521b\u5efa\u4e00\u4e2a\u540d\u5b57\u4e3a\" \/>\n\t<meta name=\"author\" content=\"Eason.Cao\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/blog.cyszys.com\/?p=89\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"zh_CN\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Eason - \u54b8\u9c7c\u54af\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b - Eason\" \/>\n\t\t<meta property=\"og:description\" content=\"\/*========================================= \/*\u521b\u5efa\u4e00\u4e2a\u540d\u5b57\u4e3a\" \/>\n\t\t<meta property=\"og:url\" content=\"http:\/\/blog.cyszys.com\/?p=89\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2014-02-21T15:55:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2014-02-21T16:03:43+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b - Eason\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\/*========================================= \/*\u521b\u5efa\u4e00\u4e2a\u540d\u5b57\u4e3a\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=89#blogposting\",\"name\":\"mysql\\u5b58\\u50a8\\u8fc7\\u7a0b\\u4e00\\u4f8b - Eason\",\"headline\":\"mysql\\u5b58\\u50a8\\u8fc7\\u7a0b\\u4e00\\u4f8b\",\"author\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#person\"},\"datePublished\":\"2014-02-21T23:55:08+08:00\",\"dateModified\":\"2014-02-22T00:03:43+08:00\",\"inLanguage\":\"zh-CN\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=89#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=89#webpage\"},\"articleSection\":\"\\u6570\\u636e\\u5e93, mysql, \\u5b58\\u50a8\\u8fc7\\u7a0b\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=89#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com#listItem\",\"position\":1,\"name\":\"\\u4e3b\\u9801\",\"item\":\"http:\\\/\\\/blog.cyszys.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?cat=11#listItem\",\"name\":\"\\u6570\\u636e\\u5e93\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?cat=11#listItem\",\"position\":2,\"name\":\"\\u6570\\u636e\\u5e93\",\"item\":\"http:\\\/\\\/blog.cyszys.com\\\/?cat=11\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=89#listItem\",\"name\":\"mysql\\u5b58\\u50a8\\u8fc7\\u7a0b\\u4e00\\u4f8b\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com#listItem\",\"name\":\"\\u4e3b\\u9801\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=89#listItem\",\"position\":3,\"name\":\"mysql\\u5b58\\u50a8\\u8fc7\\u7a0b\\u4e00\\u4f8b\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?cat=11#listItem\",\"name\":\"\\u6570\\u636e\\u5e93\"}}]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#person\",\"name\":\"Eason.Cao\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1#author\",\"url\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1\",\"name\":\"Eason.Cao\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=89#webpage\",\"url\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=89\",\"name\":\"mysql\\u5b58\\u50a8\\u8fc7\\u7a0b\\u4e00\\u4f8b - Eason\",\"description\":\"\\\/*========================================= \\\/*\\u521b\\u5efa\\u4e00\\u4e2a\\u540d\\u5b57\\u4e3a\",\"inLanguage\":\"zh-CN\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?p=89#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/?author=1#author\"},\"datePublished\":\"2014-02-21T23:55:08+08:00\",\"dateModified\":\"2014-02-22T00:03:43+08:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#website\",\"url\":\"http:\\\/\\\/blog.cyszys.com\\\/\",\"name\":\"Eason\",\"description\":\"\\u54b8\\u9c7c\\u54af\",\"inLanguage\":\"zh-CN\",\"publisher\":{\"@id\":\"http:\\\/\\\/blog.cyszys.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b - Eason","description":"\/*========================================= \/*\u521b\u5efa\u4e00\u4e2a\u540d\u5b57\u4e3a","canonical_url":"http:\/\/blog.cyszys.com\/?p=89","robots":"","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"http:\/\/blog.cyszys.com\/?p=89#blogposting","name":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b - Eason","headline":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b","author":{"@id":"http:\/\/blog.cyszys.com\/?author=1#author"},"publisher":{"@id":"http:\/\/blog.cyszys.com\/#person"},"datePublished":"2014-02-21T23:55:08+08:00","dateModified":"2014-02-22T00:03:43+08:00","inLanguage":"zh-CN","mainEntityOfPage":{"@id":"http:\/\/blog.cyszys.com\/?p=89#webpage"},"isPartOf":{"@id":"http:\/\/blog.cyszys.com\/?p=89#webpage"},"articleSection":"\u6570\u636e\u5e93, mysql, \u5b58\u50a8\u8fc7\u7a0b"},{"@type":"BreadcrumbList","@id":"http:\/\/blog.cyszys.com\/?p=89#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com#listItem","position":1,"name":"\u4e3b\u9801","item":"http:\/\/blog.cyszys.com","nextItem":{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?cat=11#listItem","name":"\u6570\u636e\u5e93"}},{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?cat=11#listItem","position":2,"name":"\u6570\u636e\u5e93","item":"http:\/\/blog.cyszys.com\/?cat=11","nextItem":{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?p=89#listItem","name":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b"},"previousItem":{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com#listItem","name":"\u4e3b\u9801"}},{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?p=89#listItem","position":3,"name":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b","previousItem":{"@type":"ListItem","@id":"http:\/\/blog.cyszys.com\/?cat=11#listItem","name":"\u6570\u636e\u5e93"}}]},{"@type":"Person","@id":"http:\/\/blog.cyszys.com\/#person","name":"Eason.Cao"},{"@type":"Person","@id":"http:\/\/blog.cyszys.com\/?author=1#author","url":"http:\/\/blog.cyszys.com\/?author=1","name":"Eason.Cao"},{"@type":"WebPage","@id":"http:\/\/blog.cyszys.com\/?p=89#webpage","url":"http:\/\/blog.cyszys.com\/?p=89","name":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b - Eason","description":"\/*========================================= \/*\u521b\u5efa\u4e00\u4e2a\u540d\u5b57\u4e3a","inLanguage":"zh-CN","isPartOf":{"@id":"http:\/\/blog.cyszys.com\/#website"},"breadcrumb":{"@id":"http:\/\/blog.cyszys.com\/?p=89#breadcrumblist"},"author":{"@id":"http:\/\/blog.cyszys.com\/?author=1#author"},"creator":{"@id":"http:\/\/blog.cyszys.com\/?author=1#author"},"datePublished":"2014-02-21T23:55:08+08:00","dateModified":"2014-02-22T00:03:43+08:00"},{"@type":"WebSite","@id":"http:\/\/blog.cyszys.com\/#website","url":"http:\/\/blog.cyszys.com\/","name":"Eason","description":"\u54b8\u9c7c\u54af","inLanguage":"zh-CN","publisher":{"@id":"http:\/\/blog.cyszys.com\/#person"}}]},"og:locale":"zh_CN","og:site_name":"Eason - \u54b8\u9c7c\u54af","og:type":"article","og:title":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b - Eason","og:description":"\/*========================================= \/*\u521b\u5efa\u4e00\u4e2a\u540d\u5b57\u4e3a","og:url":"http:\/\/blog.cyszys.com\/?p=89","article:published_time":"2014-02-21T15:55:08+00:00","article:modified_time":"2014-02-21T16:03:43+00:00","twitter:card":"summary_large_image","twitter:title":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b - Eason","twitter:description":"\/*========================================= \/*\u521b\u5efa\u4e00\u4e2a\u540d\u5b57\u4e3a"},"aioseo_meta_data":[],"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/blog.cyszys.com\" title=\"\u4e3b\u9801\">\u4e3b\u9801<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/blog.cyszys.com\/?cat=11\" title=\"\u6570\u636e\u5e93\">\u6570\u636e\u5e93<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tmysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"\u4e3b\u9801","link":"http:\/\/blog.cyszys.com"},{"label":"\u6570\u636e\u5e93","link":"http:\/\/blog.cyszys.com\/?cat=11"},{"label":"mysql\u5b58\u50a8\u8fc7\u7a0b\u4e00\u4f8b","link":"http:\/\/blog.cyszys.com\/?p=89"}],"_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}]}}