{"id":313,"date":"2019-07-29T17:09:27","date_gmt":"2019-07-29T08:09:27","guid":{"rendered":"http:\/\/e-sys.denshin.org\/blog\/?p=313"},"modified":"2019-10-01T19:44:30","modified_gmt":"2019-10-01T10:44:30","slug":"sql%e3%81%a7%e6%96%b0%e8%a6%8f%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%82%92%e4%bd%9c%e6%88%90","status":"publish","type":"post","link":"https:\/\/e-sys.ntsl.net\/?p=313","title":{"rendered":"SQL\u3067\u65b0\u898f\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210"},"content":{"rendered":"<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3001db4_php \u306b\u3001\u30b3\u30fc\u30c9\u3001\u30b0\u30c3\u30ba\u540d\u3001\u8a55\u4fa1\u984d\u3001\u753b\u50cf\u3001\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u3082\u3064\u3001\u30c6\u30fc\u30d6\u30eb\u3000[mst_goods]\u3092sql\u3067\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p>\u4e3b\u30ad\u30fc\u306f\u3001code \u306b\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002\u307e\u305f\u3001\u81ea\u52d5\u7684\u306b\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u6a5f\u80fd\u3092\u6301\u3061\u307e\u3059\u3002<\/p>\n<p>CREATE TABLE `kqc4h_db4_php`.`mst_goods3` ( `code` INT NOT NULL AUTO_INCREMENT, `g_name` VARCHAR(40) NULL , `price` INT NULL, `pic` VARCHAR(40) NULL , `time_stamp` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`code`))<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/e-sys.denshin.org\/blog\/wp-content\/uploads\/2019\/07\/2019-07-29_17h09_59.jpg\" alt=\"\" width=\"174\" height=\"195\" class=\"alignnone size-full wp-image-315\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3001db4_php \u306b\u3001\u30b3\u30fc\u30c9\u3001\u30b0\u30c3\u30ba\u540d\u3001\u8a55\u4fa1\u984d\u3001\u753b\u50cf\u3001\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7 &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-313","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=\/wp\/v2\/posts\/313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=313"}],"version-history":[{"count":5,"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=\/wp\/v2\/posts\/313\/revisions"}],"predecessor-version":[{"id":320,"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=\/wp\/v2\/posts\/313\/revisions\/320"}],"wp:attachment":[{"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e-sys.ntsl.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}