{"id":9580,"date":"2022-11-29T21:22:32","date_gmt":"2022-11-29T12:22:32","guid":{"rendered":"https:\/\/www.stechstar.com\/user\/wordpress\/?p=9580"},"modified":"2022-11-29T21:22:32","modified_gmt":"2022-11-29T12:22:32","slug":"mysql-%ec%95%84%eb%8a%94-%eb%a7%8c%ed%81%bc-%eb%b9%a8%eb%9d%bc%ec%a7%84%eb%8b%a4-%eb%a7%88%ec%9d%b4sql-%ec%84%b1%eb%8a%a5-%ed%8a%9c%eb%8b%9d-%ed%8c%81-10%ea%b0%80%ec%a7%80","status":"publish","type":"post","link":"https:\/\/www.stechstar.com\/user\/wordpress\/mysql-%ec%95%84%eb%8a%94-%eb%a7%8c%ed%81%bc-%eb%b9%a8%eb%9d%bc%ec%a7%84%eb%8b%a4-%eb%a7%88%ec%9d%b4sql-%ec%84%b1%eb%8a%a5-%ed%8a%9c%eb%8b%9d-%ed%8c%81-10%ea%b0%80%ec%a7%80\/","title":{"rendered":"[MySQL] &#8220;\uc544\ub294 \ub9cc\ud07c \ube68\ub77c\uc9c4\ub2e4&#8221; \ub9c8\uc774SQL \uc131\ub2a5 \ud29c\ub2dd \ud301 10\uac00\uc9c0\u00a0\u00a0"},"content":{"rendered":"<h1>[MySQL] &#8220;\uc544\ub294 \ub9cc\ud07c \ube68\ub77c\uc9c4\ub2e4&#8221; \ub9c8\uc774SQL \uc131\ub2a5 \ud29c\ub2dd \ud301 10\uac00\uc9c0&nbsp;&nbsp;<\/h1>\n<p>\ub9c8\uc774SQL\uc740 \uc138\uacc4\uc5d0\uc11c \uac00\uc7a5 \uad11\ubc94\uc704\ud558\uac8c \uc0ac\uc6a9\ub418\ub294 \uc624\ud508\uc18c\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc774\uba70, \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc778\uae30 \uc21c\uc704\uc5d0\uc11c\ub294 (\uadfc\uc18c\ud55c \ucc28\uc774\ub85c)&nbsp;<a href=\"https:\/\/db-engines.com\/en\/ranking\" target=\"_blank\" rel=\"noopener\" data-cke-saved-href=\"https:\/\/db-engines.com\/en\/ranking\">2\uc704<\/a>\uc5d0 \uc62c\ub77c \uc788\ub2e4. \ub9c8\uc774SQL\uc740 \ud6a8\uacfc\uc801\uc778 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc73c\ub85c \uc624\ub7ab\ub3d9\uc548 \uc778\uae30 \uc788\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc911\uc2ec\uc5d0 \uc704\uce58\ud574\uc654\ub2e4. \uadf8\ub7ec\ub098 \uc0ac\uc6a9\ud558\uae30\uac00 \uae4c\ub2e4\ub85c\uc6b8 \uc218 \uc788\uace0 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\ub294 \uc5ec\uc9c0\ub3c4 \ub9ce\ub2e4. \uc9c0\ub09c \uba87 \ub144 \ub3d9\uc548 \uba87 \uac00\uc9c0 \uc911\uc694\ud55c \uac1c\ubc1c\ub3c4 \uc774\ub904\uc84c\ub2e4. \uc5ec\uae30\uc11c\ub294 \ubc14\ub860 \uc288\uc640\ub974\uce20\uac00 \uc4f4 \ub9c8\uc774SQL \uc131\ub2a5 \ud29c\ub2dd \ud301\uc758 \uc5c5\ub370\uc774\ud2b8 \ub0b4\uc6a9\uc744 \ub2e4\ub8ec\ub2e4.&nbsp;<br \/>\n&nbsp;<\/p>\n<figure class=\"image\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/3151\/261\/089\/08f7a1b4b713ac61be42960374b7ea62.jpg\" alt=\"\" width=\"650\" height=\"487\" border=\"1\" data-autoattach=\"success\" data-cke-saved-src=\".\/files\/attach\/images\/3151\/261\/089\/08f7a1b4b713ac61be42960374b7ea62.jpg\"><figcaption>\u24d2&nbsp;Getty Images Bank<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<h2>\ub9c8\uc774SQL \uc131\ub2a5 \ud301 1. \uc2a4\ud0a4\ub9c8 \uc124\uacc4\ub294 \ub2e4\ub978 \uc5b4\ub5a4 \ub9c8\uc774SQL \uc124\uc815 \ubabb\uc9c0\uc54a\uac8c \uc911\uc694&nbsp;<\/h2>\n<p>\uc2a4\ud0a4\ub9c8 \uc124\uacc4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ud574\uc57c \ud558\ub294 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc77c \uc911 \ud558\ub098\ub2e4. \uad50\ucc28 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\uc220 \uc6d0\uce59\uc740 1970\ub144\ub300\uc5d0 \ud45c\uc900\ud615\uc774 \ub098\uc654\ub2e4. \ub9c8\uc774SQL\uc740 \ubc84\uc804 5.6\uc5d0\uc11c \uae30\ubcf8 \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc744 \uc774\ub178DB(InnoDB)\ub85c \uc804\ud658\ud588\uc73c\ubbc0\ub85c \uc2a4\ud0a4\ub9c8 \uc124\uacc4\ub294 \ub354\uc6b1 \uc911\uc694\ud574\uc84c\ub2e4.&nbsp;<\/p>\n<p>\uc774\uc720\uac00 \ubb34\uc5c7\uc77c\uae4c? \uc774\ub178DB\uc5d0\uc11c\ub294 \ubaa8\ub4e0 \uac83\uc774 \uae30\ubcf8 \ud0a4(primary key)\ub2e4. \uc774\ub294 \uc774\ub178DB\uac00 \ub370\uc774\ud130\ub97c \uc815\ub9ac\ud558\ub294 \ubc29\uc2dd\uacfc \uad00\ub828\ub41c\ub2e4. \uc774\ub178DB\uc5d0\uc11c \uae30\ubcf8 \ud0a4\ub294 \uad70\uc9d1\ud654\ub418\uace0 \ubaa8\ub4e0 \ubcf4\uc870 \ud0a4(secondary key)\ub294 \uae30\ubcf8 \ud0a4\uc5d0 \uc5d4\ud2b8\ub9ac \ud3ec\uc778\ud130\ub97c \ucd94\uac00\ud55c\ub2e4. \uc2a4\ud0a4\ub9c8 \uc124\uacc4\uc5d0\uc11c \uc774 \ubd80\ubd84\uc744 \uac10\uc548\ud558\uc9c0 \uc54a\uc73c\uba74 \uc131\ub2a5 \uce21\uba74\uc5d0\uc11c \ubd88\uc774\uc775\uc744 \ubc1b\uac8c \ub41c\ub2e4. \ub370\uc774\ud130\ub294 B-\ud2b8\ub9ac \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud574\uc11c \uc800\uc7a5\ub418\ubbc0\ub85c \ub370\uc774\ud130\ub97c \uc21c\uc11c\uac00 \uc815\ud574\uc9c4 \ubc29\uc2dd\uc73c\ub85c(\uc989, \uc720\uc0ac \uc21c\ucc28 \uac12) \uc0bd\uc785\ud558\uba74 \uae30\ubcf8 \ud0a4\uc758 \ub2e8\ud3b8\ud654\uac00 \ubc29\uc9c0\ub418\uace0 \ub530\ub77c\uc11c \ub9ac\ud504 \ub178\ub4dc\ub97c \ucc3e\ub294 \ub370 \ud544\uc694\ud55c I\/O \uc791\uc5c5\uc774 \uac10\uc18c\ud55c\ub2e4.&nbsp;<\/p>\n<p>\uc21c\ucc28 \uae30\ubcf8 \ud0a4\uac00 \ub9de\uc9c0 \uc54a\ub294 \uacbd\uc6b0\ub3c4 \uc788\ub2e4. \ub300\ud45c\uc801\uc778 \uc608\uac00 \ubc94\uc6a9 \uace0\uc720 \uc2dd\ubcc4\uc790(Universally Unique IDentifier), \uc904\uc5ec\uc11c UUID\ub2e4. UUID\uc640 \uae30\ubcf8 \ud0a4\uc5d0 \ub300\ud55c \ub354 \uc2ec\uce35\uc801\uc778 \ub0b4\uc6a9\uc740&nbsp;<a href=\"https:\/\/www.percona.com\/blog\/2019\/11\/22\/uuids-are-popular-but-bad-for-performance-lets-discuss\/\" target=\"_blank\" rel=\"noopener\" data-cke-saved-href=\"https:\/\/www.percona.com\/blog\/2019\/11\/22\/uuids-are-popular-but-bad-for-performance-lets-discuss\/\">\uc5ec\uae30<\/a>\uc11c \ubcfc \uc218 \uc788\ub2e4. \ub300\ubd80\ubd84 \uacbd\uc6b0\uc5d0\ub294 \uc21c\ucc28 \uae30\ubcf8 \ud0a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc88b\ub2e4.&nbsp;<br \/>\n&nbsp;<\/p>\n<h2>\ub9c8\uc774SQL \uc131\ub2a5 \ud301 2. \ubcf4\uc870 \ud0a4\ub97c \uc801\ub300\uc2dc\ud558\uc9c0 \ub9d0 \uac83&nbsp;<\/h2>\n<p>\ubcf4\uc870 \ud0a4\ub294 \ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4\uc5d0 \uc758\ud574 \uc5c5\ub370\uc774\ud2b8\ub418\uba70 \uc131\ub2a5 \uc601\ud5a5\uc740 \ud754\ud788 \uc0dd\uac01\ud558\ub294 \uac83\ub9cc\ud07c \ud06c\uc9c0 \uc54a\ub2e4. \ub300\uc2e0 \ubcf4\uc870 \ud0a4\ub97c \ucd94\uac00\ud558\uba74 \uc2a4\ud1a0\ub9ac\uc9c0 \uc694\uad6c\uc0ac\ud56d\uc774 \uc99d\uac00\ud558\ubbc0\ub85c \ub514\uc2a4\ud06c \uc0ac\uc6a9\ub7c9 \uce21\uba74\uc758 \ubb38\uc81c\uac00 \uc788\ub2e4. \uc778\ub371\uc2a4\uac00 \uc5c6\ub294 \ud544\ub4dc\uc5d0 \ub300\ud55c \ud544\ud130\ub9c1\uc740 \ucffc\ub9ac\uac00 \uc2e4\ud589\ub420 \ub54c\ub9c8\ub2e4 \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc744 \uc720\ubc1c\ud560 \uc218 \uc788\ub2e4. \ubb3c\ub860 \uc774 \uacbd\uc6b0 \ub9c9\ub300\ud55c \uc131\ub2a5 \uc601\ud5a5\uc774 \ubc1c\uc0dd\ud55c\ub2e4. \ub530\ub77c\uc11c \ubcf4\uc870 \ud0a4\ub294 \uc5c6\ub294 \uac83\ubcf4\ub2e4\ub294 \uc788\ub294 \ud3b8\uc774 \ub0ab\ub2e4.&nbsp;<\/p>\n<p>\ub2e8, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uacfc\ub3c4\ud55c \uc778\ub371\uc2f1\uc740 \ud53c\ud574\uc57c \ud55c\ub2e4. \ub9ce\uc740 \uc778\ub371\uc2a4\ub97c \uc2e4\ud589\ud574\ub3c4 \uc6d0\ud558\ub294 \uc131\ub2a5 \uac1c\uc120\uc744 \uc5bb\uc9c0 \ubabb\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc774\ub2e4. \ub610\ud55c \ubd80\uac00\uc801\uc778 \uc778\ub371\uc2a4\ub294 \uc2a4\ud1a0\ub9ac\uc9c0 \ube44\uc6a9\uc744 \ub192\uc77c \uc218 \uc788\uace0, \uc774\ub178DB\uac00 \uc778\ub371\uc2a4\ub97c \ucd5c\uc2e0 \uc0c1\ud0dc\ub85c \uc720\uc9c0\ud558\uae30 \uc704\ud574 \ub9ce\uc740 \ubc31\uadf8\ub77c\uc6b4\ub4dc \uc791\uc5c5\uc744 \ud574\uc57c \ud55c\ub2e4.&nbsp;<br \/>\n&nbsp;<\/p>\n<h2>\ub9c8\uc774SQL \uc131\ub2a5 \ud301 3. \uc778\ub371\uc2a4\uc5d0\uc11c \ud589 \uc81c\uacf5 \uac00\ub2a5&nbsp;<\/h2>\n<p>\uc774\ub178DB\ub294 \uc778\ub371\uc2a4\uc5d0\uc11c \ubc14\ub85c \ud589\uc744 \ucc3e\uc544\uc11c \uc81c\uacf5\ud560 \uc218 \uc788\ub294 \ubc18\uba74 \ubcf4\uc870 \ud0a4\ub294 \uae30\ubcf8 \ud0a4\ub97c \uac00\ub9ac\ud0a4\uace0 \uae30\ubcf8 \ud0a4\uc5d0\ub294 \ud589 \uc790\uccb4\uac00 \ud3ec\ud568\ub3fc \uc788\ub2e4. \ub610\ud55c \uc774\ub178DB \ubc84\ud37c \ud480\uc774 \ucda9\ubd84\ud788 \ud06c\ub2e4\uba74 \ub300\ubd80\ubd84\uc758 \ub370\uc774\ud130\ub97c \uba54\ubaa8\ub9ac\uc5d0 \uc720\uc9c0\ud560 \uc218 \uc788\ub2e4. \ub610\ud55c \ucffc\ub9ac\uc5d0\uc11c \uac1c\ubcc4\uc801\uc778 \uc5f4\ubcc4 \ud0a4\ubcf4\ub2e4 \ub300\uccb4\ub85c \ub354 \ud6a8\uacfc\uc801\uc778 \ubcf5\ud569 \ud0a4\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\ub2e4. \ub9c8\uc774SQL\uc740 \ud14c\uc774\ube14 \uc561\uc138\uc2a4\ub2f9 \ud558\ub098\uc758 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c&nbsp;WHERE x=1 and y=2\uc640 \uac19\uc740 \uc808\ub85c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\ub294 \uacbd\uc6b0&nbsp;x, y\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4\ub97c \ub450\ub294 \uac83\uc774 \uc804\uccb4 \uc5f4\uc5d0 \ub300\ud55c \uac1c\ubcc4 \uc778\ub371\uc2a4\ub97c \ub450\ub294 \uac83\ubcf4\ub2e4 \ub0ab\ub2e4.&nbsp;<\/p>\n<p>\ub610\ud55c&nbsp;x, y\uc5d0 \ub300\ud55c \ubcf5\ud569 \uc778\ub371\uc2a4\ub294 \ub2e4\uc74c \ucffc\ub9ac\uc758 \uc131\ub2a5\ub3c4 \uac1c\uc120\ud560 \uc218 \uc788\ub2e4.&nbsp;<\/p>\n<div>SELECT y FROM table WHERE x=1&nbsp;<\/div>\n<p>\ub9c8\uc774SQL\uc740 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uace0 \uc774 \uc778\ub371\uc2a4\uc5d0\uc11c \uba54\ubaa8\ub9ac\uc5d0 \uc788\ub294&nbsp;y\ub97c \uc81c\uacf5\ud55c\ub2e4. \uc2e4\ubb34\uc5d0\uc11c \ubcf5\ud569 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uae30\ud68c\uac00 \uc788\uc73c\uba74 \uc0ac\uc6a9\ud574 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\ub2e4. \uc778\ub371\uc2a4\ub97c \uc124\uacc4\ud560 \ub54c\ub294 \uc774 \uc778\ub371\uc2a4\uac00 \uc77d\ud788\ub294 \ubc29\uc2dd, \uc989 \ud56d\uc0c1 \uc67c\ucabd\uc5d0\uc11c \uc624\ub978\ucabd \ubc29\ud5a5\uc73c\ub85c \uc77d\ud78c\ub2e4\ub294 \uc810\uc744 \uc5fc\ub450\uc5d0 \ub46c\uc57c \ud55c\ub2e4. \ub2e4\uc74c \ucffc\ub9ac\ub97c \ubcf4\uc790.&nbsp;<\/p>\n<div>SELECT a,b,c FROM table WHERE a=1 and b=2&nbsp;<\/div>\n<p>\uc5ec\uae30\uc11c&nbsp;a, b\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4\ub294 \ucffc\ub9ac\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \uac83\uc774\ub2e4. \uadf8\ub7ec\ub098 \ub2e4\uc74c\uacfc \uac19\uc740 \ud615\uc2dd\uc744 \ubcf4\uc790.&nbsp;<\/p>\n<div>SELECT a,b,c FROM table WHERE b=2&nbsp;<\/div>\n<p>\uc778\ub371\uc2a4\ub294 \uc4f8\ubaa8\uac00 \uc5c6\uace0 \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc744 \uc720\ubc1c\ud55c\ub2e4. \ud56d\uc0c1 \uc67c\ucabd\ubd80\ud130 \uc778\ub371\uc2a4\ub97c \uc77d\ub294\ub2e4\ub294 \uac1c\ub150\uc740 \uc77c\ubd80 \ub2e4\ub978 \uc0ac\ub840\uc5d0\ub3c4 \uc801\uc6a9\ub41c\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c \ucffc\ub9ac\ub97c \ubcf4\uc790.&nbsp;<\/p>\n<div>SELECT a,b,c FROM table WHERE a=1 and c=2&nbsp;<\/div>\n<p>\uc5ec\uae30\uc5d0\ub294 \uc5f4&nbsp;b\uc5d0 \uc758\ud55c&nbsp;WHERE\u202f\uc808 \ud544\ud130\ub9c1\uc774 \uc5c6\uc73c\ubbc0\ub85c&nbsp;a, b, c\uc5d0 \ub300\ud55c \uc778\ub371\uc2a4\ub294 \uccab \ubc88\uc9f8 \uc5f4\ub9cc \uc77d\uac8c \ub41c\ub2e4. \ub530\ub77c\uc11c \uc774 \uacbd\uc6b0 \ub9c8\uc774SQL\uc740 \uc778\ub371\uc2a4\ub97c \ubd80\ubd84\uc801\uc73c\ub85c \uc77d\uc744 \uc218 \uc788\uace0, \uc774\uac8c \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\ubcf4\ub2e4\ub294 \ub0ab\uc9c0\ub9cc \ucd5c\uc120\uc758 \ucffc\ub9ac \uc131\ub2a5\uc744 \uc5bb\ub294 \uce21\uba74\uc5d0\uc11c\ub294 \uc5ec\uc804\ud788 \ubd80\uc871\ud558\ub2e4.&nbsp;<\/p>\n<p>\ucffc\ub9ac \uc124\uacc4\uc640 \uad00\ub828\ub41c \ub610 \ub2e4\ub978 \uc694\uc18c\ub294 \ub9c8\uc774SQL\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \uc77c\ubc18\uc801\uc778 \ucd5c\uc801\ud654\uc778 \uc67c\ucabd \ub05d \uc778\ub371\uc2a4 \uc811\uadfc\uc774\ub2e4. \uc608\ub97c \ub4e4\uc5b4&nbsp;a, b, c\uc758 \uc778\ub371\uc2a4\ub294&nbsp;select a,c where c=x\uc640 \uac19\uc740 \ucffc\ub9ac\uc5d0\uc11c\ub294 \uc791\uc6a9\ud558\uc9c0 \uc54a\ub294\ub2e4. \uc774 \ucffc\ub9ac\ub294 \uc778\ub371\uc2a4\uc758 \uccab \ubc88\uc9f8 \ubd80\ubd84, \uc989&nbsp;a, b\ub97c \uac74\ub108\ub6f8 \uc218 \uc5c6\uae30 \ub54c\ubb38\uc774\ub2e4.&nbsp;select c,count(c) where a=x group by c\uc640 \uac19\uc740 \ucffc\ub9ac\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\ub2e4.&nbsp;b\uc758 \uc778\ub371\uc2a4\ub97c \uac74\ub108\ub6f8 \uc218 \uc5c6\uc73c\ubbc0\ub85c&nbsp;group by\uc5d0 \ub300\ud574&nbsp;a, b, c\uc758 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4. \uadf8\ub7ec\ub098&nbsp;select c,count(c) where a=x and b=y group by c\uc640 \uac19\uc740 \ucffc\ub9ac\uac00 \uc788\uace0 \uc774 \ucffc\ub9ac\uac00&nbsp;a, b\uc5d0 \ub300\ud574 \ud544\ud130\ub9c1\uc744 \ud558\uace0&nbsp;c\uc5d0 \ub300\ud574&nbsp;group by\ub97c \uc218\ud589\ud55c\ub2e4\uba74&nbsp;a, b, c\uc758 \uc778\ub371\uc2a4 \ud558\ub098\uac00 \ud544\ud130\ub9c1\uacfc&nbsp;group by\uc5d0 \ubaa8\ub450 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\ub2e4.&nbsp;<\/p>\n<p>\uc6d0\ubb38\ubcf4\uae30:<br \/>\n<a href=\"https:\/\/www.itworld.co.kr\/tags\/196293\/mysql\/266739#csidxb0f62748424836c8db741e9db5d0e33\" data-cke-saved-href=\"https:\/\/www.itworld.co.kr\/tags\/196293\/mysql\/266739#csidxb0f62748424836c8db741e9db5d0e33\">https:\/\/www.itworld.co.kr\/tags\/196293\/mysql\/266739#csidxb0f62748424836c8db741e9db5d0e33&nbsp;<\/a><img decoding=\"async\" src=\"https:\/\/www.stechstar.com\/user\/zbxe\/files\/attach\/images\/3151\/261\/089\/fc3051b39cb14e554ea192b6b1a60f3f.gif\" data-autoattach=\"success\" data-cke-saved-src=\".\/files\/attach\/images\/3151\/261\/089\/fc3051b39cb14e554ea192b6b1a60f3f.gif\"><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9580\" class=\"pvc_stats all  \" data-element-id=\"9580\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.stechstar.com\/user\/wordpress\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>[MySQL] &#8220;\uc544\ub294 \ub9cc\ud07c \ube68\ub77c\uc9c4\ub2e4&#8221; \ub9c8\uc774SQL \uc131\ub2a5 \ud29c\ub2dd \ud301 10\uac00\uc9c0&nbsp;&nbsp; \ub9c8\uc774SQL\uc740 \uc138\uacc4\uc5d0\uc11c \uac00\uc7a5 \uad11\ubc94\uc704\ud558\uac8c \uc0ac\uc6a9\ub418\ub294 \uc624\ud508\uc18c\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc774\uba70, \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc778\uae30 \uc21c\uc704\uc5d0\uc11c\ub294 (\uadfc\uc18c\ud55c \ucc28\uc774\ub85c)&nbsp;2\uc704\uc5d0 \uc62c\ub77c \uc788\ub2e4. \ub9c8\uc774SQL\uc740 \ud6a8\uacfc\uc801\uc778 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc73c\ub85c \uc624\ub7ab\ub3d9\uc548 \uc778\uae30 \uc788\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc911\uc2ec\uc5d0 \uc704\uce58\ud574\uc654\ub2e4. \uadf8\ub7ec\ub098 \uc0ac\uc6a9\ud558\uae30\uac00 \uae4c\ub2e4\ub85c\uc6b8 \uc218 \uc788\uace0 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\ub294 \uc5ec\uc9c0\ub3c4 \ub9ce\ub2e4. \uc9c0\ub09c \uba87 \ub144 \ub3d9\uc548 \uba87 \uac00\uc9c0 \uc911\uc694\ud55c \uac1c\ubc1c\ub3c4 [&hellip;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9580\" class=\"pvc_stats all  \" data-element-id=\"9580\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.stechstar.com\/user\/wordpress\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[21,16,20],"tags":[],"class_list":["post-9580","post","type-post","status-publish","format-standard","hentry","category-21","category-16","category-20"],"a3_pvc":{"activated":true,"total_views":265,"today_views":0},"_links":{"self":[{"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/posts\/9580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/comments?post=9580"}],"version-history":[{"count":1,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/posts\/9580\/revisions"}],"predecessor-version":[{"id":9581,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/posts\/9580\/revisions\/9581"}],"wp:attachment":[{"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/media?parent=9580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/categories?post=9580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stechstar.com\/user\/wordpress\/wp-json\/wp\/v2\/tags?post=9580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}