{"id":55,"date":"2019-11-17T19:56:24","date_gmt":"2019-11-17T11:56:24","guid":{"rendered":"http:\/\/47.110.70.105\/wordpress\/?p=55"},"modified":"2019-12-06T11:12:33","modified_gmt":"2019-12-06T03:12:33","slug":"mysql%e7%9a%84%e5%9d%91-%e5%9c%a8%e6%95%b0%e6%8d%ae%e5%ba%93x%e4%b8%ad%e6%89%be%e4%b8%8d%e5%88%b0%e8%bf%87%e7%a8%8b%e6%88%96%e5%87%bd%e6%95%b0z","status":"publish","type":"post","link":"http:\/\/43.139.139.10\/wordpress\/55\/","title":{"rendered":"Mysql\u7684\u5751\u2014\u2014\u5728\u6570\u636e\u5e93\u201cX\u201d\u4e2d\u627e\u4e0d\u5230\u8fc7\u7a0b\u6216\u51fd\u6570\u201cZ\u201d\u3002"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>MySqlCommand cmd = new MySqlCommand(\"sp_data\", connection);\ncmd.CommandType = System.Data.CommandType.StoredProcedure;\nMySqlDataReader rdrdata = cmd.ExecuteReader();<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code><\/code><\/pre>\n\n\n\n<p>\u9519\u8bef\uff1aProcedure or function &#8216;<code>sp_data<\/code>&#8216; cannot be found in database &#8216;<code>DataBase<\/code>&#8216;.\uff08\u5728\u6570\u636e\u5e93\u201c\u6570\u636e\u5e93\u201d\u4e2d\u627e\u4e0d\u5230\u8fc7\u7a0b\u6216\u51fd\u6570\u201c sp_data\u201d\u3002\uff09<\/p>\n\n\n\n<p>\u89e3\u51b3\u65b9\u6848\uff1a \u53ea\u9700\u786e\u4fdd\u5df2\u5728\u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u8bbe\u7f6e\u4e86\u5c0f\u5199\u7684\u6570\u636e\u5e93\u540d\u79f0\u3002<\/p>\n\n\n\n<p>\u539f\u56e0\u662f\u5728Windows\u521b\u5efa\u6570\u636e\u8868\u6216\u8005\u6570\u636e\u5e93\u7684\u65f6\u5019\u9ed8\u8ba4\u90fd\u662f\u5c0f\u5199\uff0c\u8fde\u63a5\u5b57\u7b26\u4e32\u5e93\u8868\u5199\u6210\u4e86\u5927\u5b57\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySqlCommand cmd = new MySqlCommand(&#8220;sp_data&#8221;, connecti&#8230; <\/p>\n<div class=\"read-more navbutton\"><a href=\"http:\/\/43.139.139.10\/wordpress\/55\/\">\u9605\u8bfb\u66f4\u591a<i class=\"fa fa-angle-double-right\"><\/i><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":""},"categories":[8],"tags":[4],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pbrrw3-T","_links":{"self":[{"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/posts\/55"}],"collection":[{"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":5,"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/posts\/55\/revisions"}],"predecessor-version":[{"id":61,"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/posts\/55\/revisions\/61"}],"wp:attachment":[{"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/media?parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/categories?post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/43.139.139.10\/wordpress\/wp-json\/wp\/v2\/tags?post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}