\ub9e4\ubc88 \uc778\ud130\ub137\uc5d0\uc11c \ucc3e\ub2e4\uc4f0\ub2e4, \uadc0\ucc2e\uc544 \ub098\uc911\uc5d0 \ud55c\ubc88\uc5d0 \uc4f0\uae30 \uc704\ud574 \uae30\ub85d\ud55c\ub2e4.<\/p>\n
\uc544\ub798 \uc0ac\uc774\ud2b8\ub97c \ucc38\uc870\ud588\ub2e4.<\/p>\n
\uc9c0\uc6b4 \ud6c4, rollback
\nhttps:\/\/stackoverflow.com\/questions\/11011384\/how-to-test-an-sql-update-statement-before-running-it<\/p>\n
inner join
\nhttp:\/\/rapapa.net\/?p=311<\/p>\n
\uc911\ubcf5 \ub370\uc774\ud130 \ucc3e\uae30
\nhttp:\/\/ra2kstar.tistory.com\/26<\/p>\n
\uc0ac\uc9c4\uc744 database\uc5d0 \ucd94\uac00\ud558\uba74, \uac00\ub054? \uc911\ubcf5 \ub370\uc774\ud130\uac00 \uc0dd\uae34\ub2e4.\uc5b4\ub514\uac00 \ubb38\uc81c\uc778\uc9c0 \ubaa8\ub974\uaca0\uc73c\ub098, \uc911\ubcf5\ub418\ub294 \uacbd\ub85c\ub97c \uc9c0\uc6b0\uace0 \uc2f6\ub2e4.<\/p>\n
myphpadmin\uc73c\ub85c \uc784\uc2dc \ud14c\uc774\ube14\uc744 \uc791\uc131\ud558\uba74 \uc138\uc158\uc774 \ub05d\ub098\uba74\uc11c \uc8fd\uc5b4\ubc84\ub824 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4. \ud130\ubbf8\ub110\ub85c \uc5f0\uacb0\ud558\uc5ec \uc0ac\uc6a9\ud588\ub2e4.<\/p>\n
#\uc784\uc2dc \ud14c\uc774\ube14 \uc791\uc131..\nCREATE TEMPORARY TABLE if not EXISTS `toDelete` AS SELECT *, count(*) as `counter` from `picture` GROUP by `\uacbd\ub85c` HAVING `counter` >='2';\n\n#inner join\uc73c\ub85c id\uc911\ubcf5\ub418\ub294 id\ub97c \ucc3e\uc74c.\nselect `picture`.* from `picture` inner join `toDelete` on `picture`.`id` = `toDelete`.`id` limit 10;\n\n#\ubc31\uc5c5 \uc2dc\uc791..\nstart transaction;\n\n#\uc0ad\uc81c.\ndelete `picture`.* from `picture` inner join `toDelete` on `picture`.`id` = `toDelete`.`id`;\n\n#\ud655\uc778 \ud6c4,\ncommit\n\n#rollback\n<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
\ub9e4\ubc88 \uc778\ud130\ub137\uc5d0\uc11c \ucc3e\ub2e4\uc4f0\ub2e4, \uadc0\ucc2e\uc544 \ub098\uc911\uc5d0 \ud55c\ubc88\uc5d0 \uc4f0\uae30 \uc704\ud574 \uae30\ub85d\ud55c\ub2e4. \uc544\ub798 \uc0ac\uc774\ud2b8\ub97c \ucc38\uc870\ud588\ub2e4. \uc9c0\uc6b4 \ud6c4, rollback https:\/\/stackoverflow.com\/questions\/11011384\/how-to-test-an-sql-update-statement-before-running-it inner join http:\/\/rapapa.net\/?p=311 \uc911\ubcf5 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12],"tags":[13,370,54],"class_list":["post-2223","post","type-post","status-publish","format-standard","hentry","category-12","tag-mysql","tag-370","tag-54"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/2223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/comments?post=2223"}],"version-history":[{"count":1,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/2223\/revisions"}],"predecessor-version":[{"id":2227,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/2223\/revisions\/2227"}],"wp:attachment":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/media?parent=2223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/categories?post=2223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/tags?post=2223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}