{"blog_title":"\u90fd\u5143\u30c0\u30a4\u30b9\u30b1 IT-PRESS","published":"2008-04-12 17:13:16","categories":["Jiemamy"],"version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdaisuke-m.hatenablog.com%2Fentry%2F20080412%2F1207987996\" title=\"\u304c\u3093\u3070\u3063\u3066\u307e\u3059\u3002 - \u90fd\u5143\u30c0\u30a4\u30b9\u30b1 IT-PRESS\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","provider_url":"https://hatena.blog","type":"rich","url":"https://daisuke-m.hatenablog.com/entry/20080412/1207987996","height":"190","title":"\u304c\u3093\u3070\u3063\u3066\u307e\u3059\u3002","author_url":"https://blog.hatena.ne.jp/daisuke-m/","width":"100%","author_name":"daisuke-m","image_url":null,"description":"\u5b9f\u6226\u6295\u5165\u3092\u610f\u8b58\u3057\u3066\u3001\u8272\u3005\u6539\u826f\u3092\u59cb\u3081\u3066\u307e\u3059\u304c\u3001\u3082\u3046\u3061\u3063\u3068\u30ea\u30d5\u30a1\u30af\u30bf\u3057\u306a\u3044\u3068\u3044\u3058\u308a\u3065\u3089\u3044\u306a\u3041\u3001\u3068\u601d\u3046\u4eca\u65e5\u3053\u306e\u9803\u3002\u3046\u30fc\u30fc\u30fc\u30fc\u3093\u3002\u3068\u3053\u308d\u3067\u3001DB\u306eTABLE\u3068VIEW\uff08\u30b7\u30b9\u30c6\u30e0\u4ee5\u5916\uff09\u3092\u5168\u90e8\u30af\u30ea\u30a2\u3057\u3066\u3001CREATE DATABASE\u3057\u305f\u76f4\u5f8c\u306e\u72b6\u614b\u306b\u623b\u3059\u300cSQL\u300d\u306f\u7121\u3044\u3093\u3060\u308d\u3046\u304b\u3002\u3002\u3059\u3063\u3054\u3044\u6b32\u3057\u3044\uff57DROP\u2192CREATE\u3067\u3082\u826f\u3044\u3093\u3067\u3059\u304c\u3001DB2\u3060\u3068CREATE\u304c\u7570\u69d8\u306b\u9045\u304f\u3066\u30b9\u30c8\u30ec\u30b9\u3002\u304b\u3068\u3044\u3063\u3066\u3001Information Schema\u304b\u3089TABLE\u3068VIEW\u306e\u30ea\u30b9\u30c8\u3092\u5168\u90e8\u53d6\u5f97\u3057\u3066\u3001\u5916\u90e8\u30ad\u30fc\u5236\u7d04\u306e\u4f9d\u5b58\u9806\u306bDROP TABLE(VIEW)\u3057\u3066\u3044\u304f\u306e\u3082\u3001\u975e\u5e38\u306b\u3081\u3093\u3069\u304f\u3055\u3044\u3002\u305d\u306e\u4e0a\u3001\u66f8\u3044\u3066\u3044\u3066\u30aa\u30e2\u30b7\u30ed\u30af\u30ca\u30a4\uff1e\uff1c\u306c\u30fc\u30fc\u2026","blog_url":"https://daisuke-m.hatenablog.com/"}