{"id":750,"date":"2012-09-12T12:37:39","date_gmt":"2012-09-12T03:37:39","guid":{"rendered":"http:\/\/auctionpro.co.kr\/?p=750"},"modified":"2018-07-12T13:35:33","modified_gmt":"2018-07-12T04:35:33","slug":"mysql-workbench","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=750","title":{"rendered":"MySQL Workbench"},"content":{"rendered":"<p><a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/MySQL_Workbench.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-751\" title=\"MySQL_Workbench\" alt=\"\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/MySQL_Workbench.gif\" width=\"600\" height=\"376\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/MySQL_Workbench.gif 600w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/MySQL_Workbench-300x188.gif 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.mysql.com\/products\/workbench\/\">http:\/\/www.mysql.com\/products\/workbench\/<\/a><\/p>\n<p><a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench03.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2871\" alt=\"Workbench03\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench03.gif\" width=\"916\" height=\"761\" \/><\/a><br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench04.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2870\" alt=\"Workbench04\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench04.gif\" width=\"934\" height=\"664\" \/><\/a><br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench05.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2869\" alt=\"Workbench05\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench05.gif\" width=\"887\" height=\"550\" \/><\/a><br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench08.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2866\" alt=\"Workbench08\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench08.gif\" width=\"504\" height=\"386\" \/><\/a><br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench06.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2868\" alt=\"Workbench06\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench06.gif\" width=\"504\" height=\"386\" \/><\/a><br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench07.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2867\" alt=\"Workbench07\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench07.gif\" width=\"504\" height=\"386\" \/><\/a><br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench09.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2865\" alt=\"Workbench09\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench09.gif\" width=\"504\" height=\"386\" \/><\/a><br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench10.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2864\" alt=\"Workbench10\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench10.gif\" width=\"504\" height=\"386\" \/><\/a><br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench11.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2863\" alt=\"Workbench11\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench11.gif\" width=\"504\" height=\"386\" \/><\/a><br \/>\n<a href=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench12.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2862\" alt=\"Workbench12\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench12-1024x820.gif\" width=\"1000\" height=\"800\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench12-1024x820.gif 1024w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2012\/09\/Workbench12-300x240.gif 300w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p>Query update \uc2dc \ud574\uacb0 \ubc29\ubc95<br \/>\n\ucc38\uc870 : https:\/\/stackoverflow.com\/questions\/11448068\/mysql-error-code-1175-during-update-in-mysql-workbench<\/p>\n<pre class=\"lang:vim decode:true \" >You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option ....<\/pre>\n<pre class=\"lang:vim decode:true \" >SET SQL_SAFE_UPDATES = 0;<\/pre>\n<pre class=\"lang:vim decode:true \" >UPDATE wp_posts\r\nSET \r\n    post_content = REPLACE(post_content,\r\n        'http:\/\/auctionpro.co.kr\/',\r\n        'https:\/\/auctionpro.co.kr\/')\r\nWHERE\r\n    post_content LIKE '%http:\/\/auctionpro.co.kr%';<\/pre>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>http:\/\/www.mysql.com\/products\/workbench\/ Query update \uc2dc \ud574\uacb0 \ubc29\ubc95 \ucc38\uc870 : https:\/\/stackoverflow.com\/questions\/11448068\/mysql-error-code-1175-during-update-in-mysql-workbench You are using safe update mode and you tried to update a table without a WHERE <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=750\" title=\"MySQL Workbench\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[47],"tags":[],"class_list":["post-750","post","type-post","status-publish","format-standard","hentry","category-free-developer-tools"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/750","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=750"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/750\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}