{"id":532,"date":"2019-02-27T02:20:53","date_gmt":"2019-02-27T02:20:53","guid":{"rendered":"https:\/\/monyog.jp\/?p=532"},"modified":"2019-03-07T02:21:24","modified_gmt":"2019-03-07T02:21:24","slug":"%e5%88%9d%e6%9c%9f%e8%a8%ad%e5%ae%9a%e3%81%a8%e6%8e%a5%e7%b6%9a%e8%a8%ad%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/smart-style.main.jp\/monyogjp\/static\/document\/532\/index.html","title":{"rendered":"\u521d\u671f\u8a2d\u5b9a\u3068\u63a5\u7d9a\u8a2d\u5b9a"},"content":{"rendered":"

\u521d\u671f\u8a2d\u5b9a\u3068\u30b0\u30ed\u30fc\u30d0\u30eb\u8a2d\u5b9a<\/h2>\n

\u30b5\u30fc\u30d0\u30fc\u5358\u4f4d\u3067\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u306b\u52a0\u3048\u3066\u3001SQL Diagnostic Manager\u306b\u306f\u3001\u30b0\u30ed\u30fc\u30d0\u30eb\u30e6\u30fc\u30b6\u30fc\u521d\u671f\u8a2d\u5b9a\u3092\u4fdd\u5b58\u3057\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff08preferences.config\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff09\u3068SQL Diagnostic Manager\u306e\u8d77\u52d5\u306b\u5fc5\u8981\u306a\u6700\u4f4e\u9650\u306e\u60c5\u5831\u3092\u4fdd\u5b58\u3057\u305f\u3054\u304f\u5c0f\u3055\u3044\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\uff08MONyog.ini\uff09\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

connection.data<\/h3>\n

connection.data\u306b\u306f\u3001[Preferences\uff08\u521d\u671f\u8a2d\u5b9a\uff09]\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306eprocesslist\uff08\u30d7\u30ed\u30bb\u30b9\u30ea\u30b9\u30c8\uff09\u30af\u30a8\u30ea\u3092\u4fdd\u5b58\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u308b\u30c6\u30fc\u30d6\u30eb\u3067\u3059\u3002<\/p>\n

\r\nCREATE TABLE IF NOT EXISTS [preferences] (\r\n   [name] VARCHAR(50) DEFAULT '' NOT NULL PRIMARY KEY UNIQUE,\r\n   [value] TEXT DEFAULT '');\r\n<\/pre>\n

\u2018server_names\u2019\u30c6\u30fc\u30d6\u30eb\u306f\u3001\u3059\u3079\u3066\u306e\u63a5\u7d9a\u8a73\u7d30\u60c5\u5831\u3092\u4fdd\u5b58\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n

\r\nCREATE TABLE [server_names] \r\n   (id INTEGER DEFAULT 0 NOT NULL PRIMARY KEY UNIQUE, \r\n    key VARCHAR(255) DEFAULT '' NOT NULL, \r\n    value VARCHAR(255) DEFAULT '' NOT NULL);\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"

\u521d\u671f\u8a2d\u5b9a\u3068\u30b0\u30ed\u30fc\u30d0\u30eb\u8a2d\u5b9a \u30b5\u30fc\u30d0\u30fc\u5358\u4f4d\u3067\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u306b\u52a0\u3048\u3066… <\/p>\n