{"image_url":null,"provider_name":"Hatena Blog","title":"\u88cfMySQL \u30af\u30a8\u30ea\u30fc\u5165\u9580 (9) \u57fa\u790e\u7de87 \u52d5\u7684\u30af\u30a8\u30ea\u30fc","author_name":"IT7C","author_url":"https://blog.hatena.ne.jp/IT7C/","type":"rich","blog_url":"https://it7c.hatenadiary.org/","published":"2010-07-07 07:59:37","width":"100%","url":"https://it7c.hatenadiary.org/entry/20100707/1278457177","height":"190","provider_url":"https://hatena.blog","description":"MySQL\u3067\u52d5\u7684\u30af\u30a8\u30ea\u30fc\u3092\u5b9f\u884c\u3059\u308b\u70ba\u306b\u30d7\u30ea\u30da\u30a2\u30c9 \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u3044\u307e\u3059\u3002PREPARE\u3067SQL\u3092\u5b9a\u7fa9\u3057\u3001EXECUTE\u3067PREPARE\u3067\u5b9a\u7fa9\u3057\u305fSQL\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002 PREPARE stmt_name FROM preparable_stmt EXECUTE stmt_name [USING @var_name [, @var_name] ...] UPDATE\u578b\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7SQL\u3092\u4f5c\u6210\u3059\u308b\u52d5\u7684SQL SET @tbl:='pref'; SET @pkey:=(SELECT COLUMN_NAME FROM information_schema.`COLUMNS` WHERE TABLE\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fit7c.hatenadiary.org%2Fentry%2F20100707%2F1278457177\" title=\"\u88cfMySQL \u30af\u30a8\u30ea\u30fc\u5165\u9580 (9) \u57fa\u790e\u7de87 \u52d5\u7684\u30af\u30a8\u30ea\u30fc - \u30a4\u30ce\u30d9\u30fc\u30c8\u306a\u975e\u65e5\u5e38\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","categories":["mysql"],"blog_title":"\u30a4\u30ce\u30d9\u30fc\u30c8\u306a\u975e\u65e5\u5e38"}