{"version":"1.0","image_url":null,"published":"2021-12-24 23:43:25","author_name":"HTN20190109","type":"rich","blog_url":"https://htn20190109.hatenablog.com/","url":"https://htn20190109.hatenablog.com/entry/2021/12/24/234325","blog_title":"HTN20190109\u306e\u65e5\u8a18","categories":["DB"],"title":"\u9ad8\u901f\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u306e\u30c7\u30fc\u30bf\u53d6\u5f97\u5143\u30c6\u30fc\u30d6\u30eb\u3078\u306e\u5f71\u97ff\u78ba\u8a8d","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2021%2F12%2F24%2F234325\" title=\"\u9ad8\u901f\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u306e\u30c7\u30fc\u30bf\u53d6\u5f97\u5143\u30c6\u30fc\u30d6\u30eb\u3078\u306e\u5f71\u97ff\u78ba\u8a8d - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/HTN20190109/","width":"100%","description":"2\u30c6\u30fc\u30d6\u30eb\u7d50\u5408\u306e\u96c6\u8a08\u30de\u30c6\u30d3\u30e5\u30fc\u3067\u78ba\u8a8d\u30de\u30c6\u30d3\u30e5\u30fc\u3067\u53c2\u7167\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3068\u53c2\u7167\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u3067insert10\u4e07\u4ef6\u306e\u6642\u9593\u3092\u6bd4\u8f03\u3059\u308b \u7d50\u8ad6\uff1a\u9ad8\u901f\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u304c\u6709\u52b9\u306e\u5834\u5408\u3001\u66f4\u65b0\u6027\u80fd\u306f\u5927\u5e45\u306b\u52a3\u5316\u3059\u308b MySQL (8.0.27) \u524d\u63d0:\u300c\u30de\u30c6\u30d3\u30e5\u30fc\u300d\u8a18\u8f09\u624b\u9806\u3067\u30de\u30c6\u30d3\u30e5\u30fc\u74b0\u5883\u69cb\u7bc9\u6e08\u65e2\u5b58\u30eb\u30fc\u30c8\u30e6\u30fc\u30b6\u306e\u8a8d\u8a3c\u65b9\u6cd5\u5909\u66f4\u6e08alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY password; -- 1. \u53c2\u7167\u5143\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210 drop table test.order_header;drop table test.order_d\u2026","height":"190","provider_url":"https://hatena.blog"}