{"id":249,"date":"2010-12-04T15:47:02","date_gmt":"2010-12-04T06:47:02","guid":{"rendered":"http:\/\/kurosuke.org\/diary\/?p=249"},"modified":"2010-12-04T15:50:04","modified_gmt":"2010-12-04T06:50:04","slug":"mysql%e3%82%b3%e3%83%b3%e3%82%bd%e3%83%bc%e3%83%ab%e6%96%87%e5%ad%97%e5%8c%96%e3%81%91","status":"publish","type":"post","link":"https:\/\/kurosuke.org\/diary\/249","title":{"rendered":"MySQL\u30b3\u30f3\u30bd\u30fc\u30eb\u6587\u5b57\u5316\u3051"},"content":{"rendered":"<p>\u3072\u3063\u3055\u3057\u3076\u308a\u306bDB\u3044\u3058\u308b\u5fc5\u8981\u304c\u3042\u3063\u3066\u3001<br \/>\nSSH\u306a\u7a93\u3067mysql\u30b3\u30de\u30f3\u30c9\u53e9\u3044\u3066select\u6587\u5b9f\u884c\u3057\u305f\u3089??????\u3063\u3066\u8868\u793a\u3055\u308c\u305f\u306e\u3067\u30b0\u30b0\u3063\u305f\u30e1\u30e2\u3002<\/p>\n<p><!--more--><br \/>\n\u30fb\/etc\/mysql\/my.cnf \u306e[mysqld]\u9805\u306b\u4e0b\u306e\u4e8c\u884c\u3092\u8ffd\u52a0\u3002<br \/>\n<code>default-character-set = utf8<br \/>\nskip-character-set-client-handshake<\/code><\/p>\n<p>\u30fbmysql\u306e\u518d\u8d77\u52d5\u3002<\/p>\n<p>\uff72\uff85\uff8c\uff01<\/p>\n<p>\u3046\u3093\u3001\u76f4\u3063\u305f\u3002<br \/>\n\u3068\u3053\u308d\u3067\u3001\u3053\u306e\u8fba\u3063\u3066\u666e\u901a\u6700\u521d\u306b\u3084\u308b\u8a2d\u5b9a\u306a\u306e\u304b\u306a\u30fb\u30fb\u30fb<br \/>\n\u306a\u3093\u304b\u3068\u308a\u3042\u3048\u305aphp\u3068\u304b\u304b\u3089\u666e\u901a\u306b\u4f7f\u3048\u3066\u308b\u304b\u3089\u7279\u306b\u305d\u306e\u8fba\u6c17\u306b\u3057\u306a\u3044\u3067\u4f7f\u3063\u3066\u305f\u3088\u30fb\u30fb\u30fb\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3072\u3063\u3055\u3057\u3076\u308a\u306bDB\u3044\u3058\u308b\u5fc5\u8981\u304c\u3042\u3063\u3066\u3001 SSH\u306a\u7a93\u3067mysql\u30b3\u30de\u30f3\u30c9\u53e9\u3044\u3066se &hellip;<\/p>\n<p class=\"read-more\"><a href=\"https:\/\/kurosuke.org\/diary\/249\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[19],"jetpack_publicize_connections":[],"views":451,"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p49qdv-41","jetpack_likes_enabled":false,"jetpack-related-posts":[{"id":377,"url":"https:\/\/kurosuke.org\/diary\/377","url_meta":{"origin":249,"position":0},"title":"jQuery.post\u3068php\u3068mySQL\u3068\u79c1\u3002","author":"xxxkurosukexxx","date":"2011\/12\/24","format":false,"excerpt":"\u30bf\u30a4\u30c8\u30eb\u9577\u3044\u3088\u81ea\u91cd\u3057\u308d\uff01 \u4ed5\u4e8b\u3067\u305d\u3093\u306a\u3053\u3068\u3092\u3059\u308b\u6a5f\u4f1a\u304c\u3042\u3063\u305f\u306e\u3067\u899a\u3048\u66f8\u304d\u3002 Ajax\u3067\u88cf\u3067\u901a\u4fe1\u3057\u3066\u30da\u2026","rel":"","context":"\u65e5\u8a18","block_context":{"text":"\u65e5\u8a18","link":"https:\/\/kurosuke.org\/diary\/category\/diary"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":533,"url":"https:\/\/kurosuke.org\/diary\/533","url_meta":{"origin":249,"position":1},"title":"Redmine\u3092\u5c0e\u5165\u3057\u307e\u3057\u305f","author":"xxxkurosukexxx","date":"2014\/01\/29","format":false,"excerpt":"\u3044\u3044\u52a0\u6e1b\u30bf\u30b9\u30af\u7ba1\u7406\u3067\u3082\u59cb\u3081\u3088\u3046\u304b\u306a\u3068\u601d\u3044\u307e\u3057\u3066\u3001\u30ca\u30a6\u306a\u30e4\u30f3\u30b0\u306b\u30d0\u30ab\u30a6\u30b1\u306e\uff08\uff09\u306eRedmine\u3092\u5c0e\u5165\u3057\u2026","rel":"","context":"\u6280\u8853\u7cfb\u8a18\u4e8b","block_context":{"text":"\u6280\u8853\u7cfb\u8a18\u4e8b","link":"https:\/\/kurosuke.org\/diary\/category\/tech"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/kurosuke.org\/diary\/wp-content\/uploads\/2014\/01\/redmine_logo_v1.png?fit=600%2C200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/kurosuke.org\/diary\/wp-content\/uploads\/2014\/01\/redmine_logo_v1.png?fit=600%2C200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/kurosuke.org\/diary\/wp-content\/uploads\/2014\/01\/redmine_logo_v1.png?fit=600%2C200&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":476,"url":"https:\/\/kurosuke.org\/diary\/476","url_meta":{"origin":249,"position":2},"title":"Amazon\u3068\u9023\u643a\u3057\u3066\u81ea\u708a\u672c\u3092\u7ba1\u7406\u3059\u308b\u304a\u3082\u3061\u3083\u4f5c\u3063\u305f","author":"xxxkurosukexxx","date":"2013\/05\/18","format":false,"excerpt":"\u306f\u3044\u3069\u30fc\u3082\u3053\u3093\u306b\u3061\u308f\u3002 Sony Reader PRS-T2\u3092\u8cb7\u3063\u3066\u304b\u3089\u8aad\u66f8\u71b1\u304c\u4e0a\u304c\u308a\u3001\u4e45\u3057\u3076\u308a\u306b\u81ea\u2026","rel":"","context":"\u6280\u8853\u7cfb\u8a18\u4e8b","block_context":{"text":"\u6280\u8853\u7cfb\u8a18\u4e8b","link":"https:\/\/kurosuke.org\/diary\/category\/tech"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/kurosuke.org\/diary\/wp-content\/uploads\/2013\/05\/amazon-260x300.gif?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":250,"url":"https:\/\/kurosuke.org\/diary\/250","url_meta":{"origin":249,"position":3},"title":"mediatomb\u76f4\u3063\u305f\u30e1\u30e2","author":"xxxkurosukexxx","date":"2010\/12\/07","format":false,"excerpt":"mediatomb\u3068\u3044\u3046\u3001DLNA\u30b5\u30fc\u30d0\u304c\u3044\u3064\u304b\u3089\u304b\u6a5f\u5acc\u304c\u60aa\u304f\u306a\u3063\u3066\u3057\u307e\u3063\u3066\u3044\u3066\u3001\u4e00\u5207\u52d5\u753b\u304c\u898b\u308c\u306a\u304f\u2026","rel":"","context":"\u6280\u8853\u7cfb\u8a18\u4e8b","block_context":{"text":"\u6280\u8853\u7cfb\u8a18\u4e8b","link":"https:\/\/kurosuke.org\/diary\/category\/tech"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":43,"url":"https:\/\/kurosuke.org\/diary\/43","url_meta":{"origin":249,"position":4},"title":"\u308f\u3063\u3057\u3087\u3044\uff01","author":"xxxkurosukexxx","date":"2010\/01\/06","format":false,"excerpt":"Windows\u306f\u3042\u308b\u7a0b\u5ea6\u9069\u5f53\u3067\u3082\u306a\u3093\u3068\u304b\u306a\u308b\u3051\u3069\u3001Linux\u306f\u305d\u3046\u306f\u3044\u304b\u306a\u3044\u307f\u305f\u3044\u3067\u3059\u3002 \u305f\u3068\u3048\u3070\u3001\u2026","rel":"","context":"\u65e5\u8a18","block_context":{"text":"\u65e5\u8a18","link":"https:\/\/kurosuke.org\/diary\/category\/diary"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":251,"url":"https:\/\/kurosuke.org\/diary\/251","url_meta":{"origin":249,"position":5},"title":"twlog\u306e\u6587\u5b57\u5316\u3051\u3002","author":"xxxkurosukexxx","date":"2010\/12\/07","format":false,"excerpt":"\u30b5\u30a4\u30c8\u306bTwitter\u306e\u30ed\u30b0\u53ce\u96c6\u3057\u3066\u8f09\u305b\u3066\u307e\u3059\u304c\u3001\uff08URL\uff09\u3001\u3053\u3053\u3057\u3070\u3089\u304f\u8fd4\u4fe1\u5143\u306eTweet\u53d6\u5f97\u3057\u3066\u2026","rel":"","context":"\u65e5\u8a18","block_context":{"text":"\u65e5\u8a18","link":"https:\/\/kurosuke.org\/diary\/category\/diary"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/kurosuke.org\/diary\/wp-json\/wp\/v2\/posts\/249"}],"collection":[{"href":"https:\/\/kurosuke.org\/diary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kurosuke.org\/diary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kurosuke.org\/diary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kurosuke.org\/diary\/wp-json\/wp\/v2\/comments?post=249"}],"version-history":[{"count":0,"href":"https:\/\/kurosuke.org\/diary\/wp-json\/wp\/v2\/posts\/249\/revisions"}],"wp:attachment":[{"href":"https:\/\/kurosuke.org\/diary\/wp-json\/wp\/v2\/media?parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kurosuke.org\/diary\/wp-json\/wp\/v2\/categories?post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kurosuke.org\/diary\/wp-json\/wp\/v2\/tags?post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}