{"id":3022,"date":"2026-05-09T21:50:59","date_gmt":"2026-05-09T13:50:59","guid":{"rendered":"https:\/\/tekno.bali-island.com\/?p=3022"},"modified":"2026-05-09T21:51:02","modified_gmt":"2026-05-09T13:51:02","slug":"ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql","status":"publish","type":"post","link":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/","title":{"rendered":"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>\ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4(DDL) \uc18c\uac1c<\/strong><\/h2>\n\n\n\n<p><strong>DDL<\/strong>\uc740&nbsp;<em>Data Definition Language<\/em>\uc758 \uc57d\uc790\ub85c, SQL(<em>Structured Query Language<\/em>)\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub97c \uc804\ubc18\uc801\uc73c\ub85c \uae30\uc220\ud558\uae30 \uc704\ud55c \uba85\ub839\uc5b4 \uc9d1\ud569\uc785\ub2c8\ub2e4. DDL\uc758 \uc8fc\uc694 \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CREATE<\/strong>: \uc0c8\ub85c\uc6b4 \uac1d\uccb4\ub97c \uc0dd\uc131\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>ALTER<\/strong>: \uae30\uc874 \uac1d\uccb4\uc758 \uad6c\uc870\ub97c \ubcc0\uacbd\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>DROP<\/strong>: \uac1d\uccb4\ub97c \uc0ad\uc81c\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>MySQL\uc5d0\uc11c CREATE, ALTER, DROP \uba85\ub839\uc5b4 \uc0ac\uc6a9<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>a. CREATE<\/strong><\/h3>\n\n\n\n<p>CREATE \uba85\ub839\uc5b4\ub294 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4, \uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14 \ub610\ub294 \uc0c8\ub85c\uc6b4&nbsp;<em>\ubdf0<\/em>\ub97c \uc0dd\uc131\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc608:<\/strong>\u00a0CREATE DATABASE toko_buku;<\/li>\n\n\n\n<li><strong>\uc124\uba85:<\/strong>\u00a0\uc774 \uba85\ub839\uc5b4\ub294 toko_buku\ub77c\ub294 \uc774\ub984\uc758 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>b. ALTER<\/strong><\/h3>\n\n\n\n<p>ALTER \uba85\ub839\uc5b4\ub294 \uc774\ubbf8 \uc0dd\uc131\ub41c \ud14c\uc774\ube14\uc758 \uad6c\uc870\ub97c \ubcc0\uacbd\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc774 \uc791\uc5c5\uc740 \uc5f4\uc744 \ucd94\uac00, \uc0ad\uc81c, \ubcc0\uacbd\ud558\uac70\ub098 \ud14c\uc774\ube14\uc744 \uc218\uc815\ud558\uace0 \uc5f4\uc5d0 \uc0c8\ub85c\uc6b4 \uc18d\uc131\uc744 \ubd80\uc5ec\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc608:<\/strong>\u00a0ALTER TABLE buku ADD judul_buku varchar(20);<\/li>\n\n\n\n<li><strong>\uc124\uba85:<\/strong>\u00a0\uc774 \uba85\ub839\uc5b4\ub294 buku \ud14c\uc774\ube14\uc5d0 \ucd5c\ub300 20\uc790\uc758 varchar \ub370\uc774\ud130 \uc720\ud615\uc744 \uac00\uc9c0\ub294 judul_buku\ub77c\ub294 \uc0c8\ub85c\uc6b4\u00a0<em>\ud544\ub4dc<\/em>(\uc5f4)\ub97c \ucd94\uac00\ud558\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>c. DROP<\/strong><\/h3>\n\n\n\n<p>DROP \uba85\ub839\uc5b4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uac1d\uccb4\ub97c \uc601\uad6c\uc801\uc73c\ub85c \uc0ad\uc81c\ud569\ub2c8\ub2e4. \uac1d\uccb4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc790\uccb4, \ud14c\uc774\ube14,&nbsp;<em>\ud568\uc218<\/em>,&nbsp;<em>\uc778\ub371\uc2a4<\/em>,&nbsp;<em>\ud504\ub85c\uc2dc\uc800<\/em>,&nbsp;<em>\ud2b8\ub9ac\uac70<\/em>&nbsp;\ub610\ub294&nbsp;<em>\ubdf0<\/em>\uac00 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc608:<\/strong>\u00a0DROP DATABASE toko_buku;<\/li>\n\n\n\n<li><strong>\uc124\uba85:<\/strong>\u00a0\uc774 \uba85\ub839\uc5b4\ub294 toko_buku\ub77c\ub294 \uc774\ub984\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ad\uc81c\ud558\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>MySQL\uc758 \ub370\uc774\ud130 \uc720\ud615<\/strong><\/h2>\n\n\n\n<p>\uc801\uc808\ud55c \ub370\uc774\ud130 \uc720\ud615\uc758 \uc120\ud0dd\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc800\uc7a5 \ud6a8\uc728\uc131\uc5d0 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 MySQL\uc758 \ub370\uc774\ud130 \uc720\ud615 \ubc94\uc8fc\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. \uc22b\uc790 \ub370\uc774\ud130 \uc720\ud615<\/strong><\/h3>\n\n\n\n<p>\uc22b\uc790 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>TINYINT:<\/strong>\u00a0\uc815\uc218(\uc591\uc218\/\uc74c\uc218)\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: -128 ~ 127. \ud06c\uae30: 1\ubc14\uc774\ud2b8 (8\ube44\ud2b8).<\/li>\n\n\n\n<li><strong>SMALLINT:<\/strong>\u00a0\uc815\uc218\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: -32768 ~ 32767. \ud06c\uae30: 2\ubc14\uc774\ud2b8 (16\ube44\ud2b8).<\/li>\n\n\n\n<li><strong>MEDIUMINT:<\/strong>\u00a0\uc815\uc218\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: -8388608 ~ 8388607. \ud06c\uae30: 3\ubc14\uc774\ud2b8 (24\ube44\ud2b8).<\/li>\n\n\n\n<li><strong>INT:<\/strong>\u00a0\uc815\uc218\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: -2147483648 ~ 2147483647. \ud06c\uae30: 4\ubc14\uc774\ud2b8 (32\ube44\ud2b8).<\/li>\n\n\n\n<li><strong>BIGINT:<\/strong>\u00a0\ud070 \ubc94\uc704\uc758 \uc815\uc218\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: -9223372036854775808 ~ 9223372036854775807. \ud06c\uae30: 8\ubc14\uc774\ud2b8 (64\ube44\ud2b8).<\/li>\n\n\n\n<li><strong>FLOAT:<\/strong>\u00a0\ub2e8\uc815\ub3c4 \ubd80\ub3d9 \uc18c\uc218\uc810 \uc22b\uc790\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ud06c\uae30: 4\ubc14\uc774\ud2b8 (32\ube44\ud2b8).<\/li>\n\n\n\n<li><strong>DOUBLE \/ REAL:<\/strong>\u00a0\ubc30\uc815\ub3c4 \ubd80\ub3d9 \uc18c\uc218\uc810 \uc22b\uc790\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ud06c\uae30: 8\ubc14\uc774\ud2b8 (64\ube44\ud2b8).<\/li>\n\n\n\n<li><strong>DECIMAL \/ NUMERIC:<\/strong>\u00a0\ub9e4\uc6b0 \ub192\uc740 \uc815\ubc00\ub3c4\uc758 \uace0\uc815 \uc18c\uc218\uc810 \uc22b\uc790\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ud06c\uae30: 8\ubc14\uc774\ud2b8 (64\ube44\ud2b8).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. \ubb38\uc790\uc5f4 \ub370\uc774\ud130 \uc720\ud615 (\ud14d\uc2a4\ud2b8)<\/strong><\/h3>\n\n\n\n<p>\ubb38\uc790 \ub610\ub294 \ud14d\uc2a4\ud2b8 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CHAR:<\/strong>\u00a0\uace0\uc815 \uae38\uc774 \ubb38\uc790\uc5f4 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4 (\uc608: \uc0c1\ud488 ID, \uc8fc\ubbfc\ub4f1\ub85d\ubc88\ud638). \ubc94\uc704: 0 ~ 255\uc790.<\/li>\n\n\n\n<li><strong>VARCHAR:<\/strong>\u00a0\uac00\ubcc0 \uae38\uc774 \ubb38\uc790\uc5f4 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: 0 ~ 65,535\uc790 (\ucd5c\uc2e0 \ubc84\uc804).<\/li>\n\n\n\n<li><strong>TINYTEXT:<\/strong>\u00a0\uc9e7\uc740 \ud14d\uc2a4\ud2b8 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: 0 ~ 255\uc790.<\/li>\n\n\n\n<li><strong>TEXT:<\/strong>\u00a0\ud45c\uc900 \ud14d\uc2a4\ud2b8 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: 0 ~ 65,535\uc790.<\/li>\n\n\n\n<li><strong>MEDIUMTEXT:<\/strong>\u00a0\uc911\uac04 \uae38\uc774\uc758 \ud14d\uc2a4\ud2b8 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: 0 ~ 16,777,215\uc790.<\/li>\n\n\n\n<li><strong>LONGTEXT:<\/strong>\u00a0\ub9e4\uc6b0 \uae34 \ud14d\uc2a4\ud2b8 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: 0 ~ 4,294,967,295\uc790.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. \ub0a0\uc9dc \ubc0f \uc2dc\uac04 \ub370\uc774\ud130 \uc720\ud615<\/strong><\/h3>\n\n\n\n<p>\ub0a0\uc9dc\uc640 \uc2dc\uac04 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>DATE:<\/strong>\u00a0\ub0a0\uc9dc\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4 (\ud615\uc2dd: YYYY-MM-DD). \ubc94\uc704: &#8216;1000-01-01&#8217; ~ &#8216;9999-12-31&#8217;. \ud06c\uae30: 3\ubc14\uc774\ud2b8.<\/li>\n\n\n\n<li><strong>TIME:<\/strong>\u00a0\uc2dc\uac04\uc744 \uc800\uc7a5\ud569\ub2c8\ub2e4 (\ud615\uc2dd: HH:MM:SS). \ubc94\uc704: &#8216;-838:59:59&#8217; ~ &#8216;+838:59:59&#8217;. \ud06c\uae30: 3\ubc14\uc774\ud2b8.<\/li>\n\n\n\n<li><strong>DATETIME:<\/strong>\u00a0\ub0a0\uc9dc\uc640 \uc2dc\uac04\uc758 \uc870\ud569\uc744 \uc800\uc7a5\ud569\ub2c8\ub2e4 (\ud615\uc2dd: YYYY-MM-DD HH:MM:SS). \ubc94\uc704: &#8216;1000-01-01 00:00:00&#8217; ~ &#8216;9999-12-31 23:59:59&#8217;. \ud06c\uae30: 8\ubc14\uc774\ud2b8.<\/li>\n\n\n\n<li><strong>YEAR:<\/strong>\u00a0\uc5f0\ub3c4\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4 (\ud615\uc2dd: YYYY). \ubc94\uc704: 1900 ~ 2155. \ud06c\uae30: 1\ubc14\uc774\ud2b8.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. BLOB \ub370\uc774\ud130 \uc720\ud615 (\ubc14\uc774\ub108\ub9ac)<\/strong><\/h3>\n\n\n\n<p>BLOB\uc740&nbsp;<em>Binary Large Object<\/em>\uc758 \uc57d\uc790\uc785\ub2c8\ub2e4. \uc21c\uc218 \uc774\uc9c4 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\uba70,&nbsp;<em>\ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84<\/em>\ud558\uba70 \uc774\ubbf8\uc9c0, \ubb38\uc11c, \uc624\ub514\uc624 \ub4f1\uc758 \uba40\ud2f0\ubbf8\ub514\uc5b4 \ud30c\uc77c\uc5d0 \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>BIT:<\/strong>\u00a0\uc774\uc9c4 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ubc94\uc704: 64\uac1c\uc758 \uc774\uc9c4 \uc790\ub9bf\uc218.<\/li>\n\n\n\n<li><strong>TINYBLOB:<\/strong>\u00a0\ucd5c\ub300 \ud06c\uae30 255\ubc14\uc774\ud2b8.<\/li>\n\n\n\n<li><strong>BLOB:<\/strong>\u00a0\ucd5c\ub300 \ud06c\uae30 65,535\ubc14\uc774\ud2b8.<\/li>\n\n\n\n<li><strong>MEDIUMBLOB:<\/strong>\u00a0\ucd5c\ub300 \ud06c\uae30 16,777,215\ubc14\uc774\ud2b8.<\/li>\n\n\n\n<li><strong>LONGBLOB:<\/strong>\u00a0\ucd5c\ub300 \ud06c\uae30 4,294,967,295\ubc14\uc774\ud2b8.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>SQL\uc758 \ud0a4 \uc720\ud615<\/strong><\/h2>\n\n\n\n<p>SQL\uc5d0\uc11c \ud0a4\ub294 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \ud589\uc744 \uace0\uc720\ud558\uac8c \uad6c\ubd84\ud558\uac70\ub098 \ud55c \ud14c\uc774\ube14\uc744 \ub2e4\ub978 \ud14c\uc774\ube14\uacfc \uc5f0\uacb0(\uad00\uacc4)\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \uc18d\uc131(\uc5f4) \uc870\ud569\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc288\ud37c \ud0a4:<\/strong>\u00a0\ud14c\uc774\ube14\uc758 \uac01 \ub370\uc774\ud130 \ud589\uc744 \uace0\uc720\ud558\uac8c \uc2dd\ubcc4\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc18d\uc131 \uc9d1\ud569\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ud6c4\ubcf4 \ud0a4:<\/strong>\u00a0\uc911\ubcf5 \uc18d\uc131\uc774 \uc5c6\ub294 \ucd5c\uc18c \uc288\ud37c \ud0a4\uc785\ub2c8\ub2e4. \ud6c4\ubcf4 \ud0a4\ub294 \uace0\uc720\ud55c \uac12\uc744 \uc2dd\ubcc4\ud560 \uc218 \uc788\ub294 \uac00\uc7a5 \uc791\uc740\u00a0<em>\ud544\ub4dc<\/em>\u00a0\uc870\ud569\uc5d0\uc11c \uc120\ud0dd\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uae30\ubcf8 \ud0a4:<\/strong>\u00a0<em>\ub808\ucf54\ub4dc<\/em>\uc758 \uc8fc\uc694 \uc2dd\ubcc4\uc790\ub85c \uc120\ud0dd\ub41c \ud6c4\ubcf4 \ud0a4\uc785\ub2c8\ub2e4. \uae30\ubcf8 \ud0a4\uc758 \ub370\uc774\ud130\ub294\u00a0<strong>\ube44\uc6cc\ub458 \uc218 \uc5c6\uace0<\/strong>\u00a0(<em>Not Null<\/em>)\u00a0<strong>\uc911\ubcf5\ub420 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4<\/strong>. \uac01 \ud14c\uc774\ube14\uc740 \ud558\ub098\uc758 \uae30\ubcf8 \ud0a4\ub9cc \uac00\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ub300\uccb4 \ud0a4:<\/strong>\u00a0\uae30\ubcf8 \ud0a4\ub85c\u00a0<em>\uc120\ud0dd\ub418\uc9c0 \uc54a\uc740<\/em>\u00a0\ud6c4\ubcf4 \ud0a4\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uc678\ub798 \ud0a4:<\/strong>\u00a0\ud55c \ud14c\uc774\ube14\uc744 \ub2e4\ub978 \ud14c\uc774\ube14\uacfc \uc5f0\uacb0\ud558\uc5ec\u00a0<em>\ubd80\ubaa8-\uc790\uc2dd<\/em>\u00a0\uad00\uacc4\ub97c \ud615\uc131\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \ud0a4\uc785\ub2c8\ub2e4. \ubd80\ubaa8 \ud14c\uc774\ube14\uc758 \uae30\ubcf8 \ud0a4\ub294 \uad00\ub828(\uc790\uc2dd) \ud14c\uc774\ube14\uc758 \uc678\ub798 \ud0a4\uc5d0 \uc758\ud574 \ucc38\uc870\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ubcf5\ud569 \ud0a4:<\/strong>\u00a0\uc5d4\ud130\ud2f0\ub97c \uace0\uc720\ud558\uac8c \uc2dd\ubcc4\ud558\uae30 \uc704\ud574 \ub450 \uac1c \uc774\uc0c1\uc758 \uc18d\uc131\uc73c\ub85c \uad6c\uc131\ub41c \ud0a4\uc785\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uae30\ubcf8 \ud0a4 \uc694\uac74\uc744 \ucda9\uc871\ud558\ub294 \ub2e8\uc77c \uc5f4\uc774 \uc5c6\uc744 \ub54c \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>MySQL\uc758 \uc81c\uc57d \uc870\uac74 \uc720\ud615<\/strong><\/h2>\n\n\n\n<p><em>\uc81c\uc57d \uc870\uac74<\/em>\uc740 \ub370\uc774\ud130 \ubb34\uacb0\uc131\uacfc \uc720\ud6a8\uc131\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud574 \uc5f4\uc774\ub098 \ud14c\uc774\ube14\uc5d0 \uc801\uc6a9\ub418\ub294 \uc81c\ud55c \uaddc\uce59\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>NOT NULL:<\/strong>\u00a0<em>\ub808\ucf54\ub4dc<\/em>\u00a0\uc0bd\uc785 \uc2dc \uc5f4\uc744 \ube44\uc6cc\ub458 \uc218 \uc5c6\ub3c4\ub85d \ubcf4\uc7a5\ud569\ub2c8\ub2e4. \ud574\ub2f9 \uc5f4\uc740 \ubc18\ub4dc\uc2dc \ub370\uc774\ud130\ub85c \ucc44\uc6cc\uc838\uc57c \ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>UNIQUE:<\/strong>\u00a0\uc5f4 \ub0b4\uc758 \ubaa8\ub4e0 \uac12\uc774 \uc11c\ub85c \ub2e4\ub974\ub3c4\ub85d \ubcf4\uc7a5\ud569\ub2c8\ub2e4 (\ub808\ucf54\ub4dc \uc911\ubcf5 \uc5c6\uc74c).<\/li>\n\n\n\n<li><strong>PRIMARY KEY:<\/strong>\u00a0NOT NULL\uacfc UNIQUE \uc81c\uc57d \uc870\uac74\uc758 \uc870\ud569\uc785\ub2c8\ub2e4. \ud14c\uc774\ube14\uc758 \uac01 \ud589\uc744 \uace0\uc720\ud558\uac8c \uc2dd\ubcc4\ud569\ub2c8\ub2e4. \ud14c\uc774\ube14\ub2f9 \ud558\ub098\uc758 PRIMARY KEY\ub9cc \ud5c8\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>FOREIGN KEY:<\/strong>\u00a0\ud14c\uc774\ube14 \uac04\uc758 \ucc38\uc870 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud569\ub2c8\ub2e4.\u00a0<em>\uc790\uc2dd<\/em>\u00a0\uc5f4\uc758 \uac12\uc774\u00a0<em>\ubd80\ubaa8<\/em>\u00a0\uc5f4(\ub2e4\ub978 \ud14c\uc774\ube14)\uc5d0 \uc720\ud6a8\ud55c \ucc38\uc870\ub97c \uac00\uc9c0\uace0 \uc788\uc74c\uc744 \ubcf4\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>CHECK:<\/strong>\u00a0\ub370\uc774\ud130\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub418\uae30 \uc804\uc5d0 \uc720\ud6a8\uc131 \uac80\uc0ac \ub610\ub294 \ud655\uc778\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ub294\u00a0<em>boolean<\/em>\u00a0\uac12\uc73c\ub85c \ud3c9\uac00\ub418\uba70, \uc870\uac74\uc744 \ucda9\uc871\ud558\uba74\u00a0<em>true<\/em>\uac00 \ub418\uc5b4 \uc800\uc7a5\ub418\uc9c0\ub9cc,\u00a0<em>false<\/em>\uc774\uba74 SQL\uc774 \uac70\ubd80\ud558\uace0\u00a0<em>\uc624\ub958<\/em>\u00a0\uba54\uc2dc\uc9c0\ub97c \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4(DDL) \uc18c\uac1c DDL\uc740&nbsp;Data Definition Language\uc758 \uc57d\uc790\ub85c, SQL(Structured Query Language)\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub97c \uc804\ubc18\uc801\uc73c\ub85c \uae30\uc220\ud558\uae30 \uc704\ud55c \uba85\ub839\uc5b4 \uc9d1\ud569\uc785\ub2c8\ub2e4. DDL\uc758 \uc8fc\uc694 \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. MySQL\uc5d0\uc11c CREATE, ALTER, DROP \uba85\ub839\uc5b4 \uc0ac\uc6a9 a. CREATE CREATE \uba85\ub839\uc5b4\ub294 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4, \uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14 \ub610\ub294 \uc0c8\ub85c\uc6b4&nbsp;\ubdf0\ub97c \uc0dd\uc131\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. b. ALTER ALTER \uba85\ub839\uc5b4\ub294 \uc774\ubbf8 \uc0dd\uc131\ub41c \ud14c\uc774\ube14\uc758 \uad6c\uc870\ub97c \ubcc0\uacbd\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc774 \uc791\uc5c5\uc740 \uc5f4\uc744 \ucd94\uac00, \uc0ad\uc81c, \ubcc0\uacbd\ud558\uac70\ub098 \ud14c\uc774\ube14\uc744 \uc218\uc815\ud558\uace0 \uc5f4\uc5d0 \uc0c8\ub85c\uc6b4 \uc18d\uc131\uc744 \ubd80\uc5ec\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. c. DROP DROP \uba85\ub839\uc5b4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uac1d\uccb4\ub97c \uc601\uad6c\uc801\uc73c\ub85c \uc0ad\uc81c\ud569\ub2c8\ub2e4. \uac1d\uccb4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc790\uccb4, \ud14c\uc774\ube14,&nbsp;\ud568\uc218,&nbsp;\uc778\ub371\uc2a4,&nbsp;\ud504\ub85c\uc2dc\uc800,&nbsp;\ud2b8\ub9ac\uac70&nbsp;\ub610\ub294&nbsp;\ubdf0\uac00 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. MySQL\uc758 \ub370\uc774\ud130 \uc720\ud615 \uc801\uc808\ud55c \ub370\uc774\ud130 \uc720\ud615\uc758 \uc120\ud0dd\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc800\uc7a5 \ud6a8\uc728\uc131\uc5d0 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 MySQL\uc758 \ub370\uc774\ud130 \uc720\ud615 \ubc94\uc8fc\uc785\ub2c8\ub2e4. A. \uc22b\uc790 \ub370\uc774\ud130 \uc720\ud615 \uc22b\uc790 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. B. \ubb38\uc790\uc5f4 \ub370\uc774\ud130 \uc720\ud615 (\ud14d\uc2a4\ud2b8) \ubb38\uc790 \ub610\ub294 \ud14d\uc2a4\ud2b8 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. C. \ub0a0\uc9dc \ubc0f \uc2dc\uac04 \ub370\uc774\ud130 \uc720\ud615 \ub0a0\uc9dc\uc640 \uc2dc\uac04 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. D. BLOB \ub370\uc774\ud130 \uc720\ud615 (\ubc14\uc774\ub108\ub9ac) BLOB\uc740&nbsp;Binary Large Object\uc758 \uc57d\uc790\uc785\ub2c8\ub2e4. \uc21c\uc218 \uc774\uc9c4 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\uba70,&nbsp;\ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uba70 \uc774\ubbf8\uc9c0, \ubb38\uc11c, \uc624\ub514\uc624 \ub4f1\uc758 \uba40\ud2f0\ubbf8\ub514\uc5b4 \ud30c\uc77c\uc5d0 \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4. SQL\uc758 \ud0a4 \uc720\ud615 SQL\uc5d0\uc11c \ud0a4\ub294 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \ud589\uc744 \uace0\uc720\ud558\uac8c \uad6c\ubd84\ud558\uac70\ub098 \ud55c \ud14c\uc774\ube14\uc744 \ub2e4\ub978 \ud14c\uc774\ube14\uacfc \uc5f0\uacb0(\uad00\uacc4)\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \uc18d\uc131(\uc5f4) \uc870\ud569\uc785\ub2c8\ub2e4. MySQL\uc758 \uc81c\uc57d \uc870\uac74 \uc720\ud615 \uc81c\uc57d \uc870\uac74\uc740 \ub370\uc774\ud130 \ubb34\uacb0\uc131\uacfc \uc720\ud6a8\uc131\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud574 \uc5f4\uc774\ub098 \ud14c\uc774\ube14\uc5d0 \uc801\uc6a9\ub418\ub294 \uc81c\ud55c \uaddc\uce59\uc785\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":3003,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[101],"tags":[],"class_list":["post-3022","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-101"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)<\/title>\n<meta name=\"description\" content=\"\ucd08\ubcf4\uc790\ub97c \uc704\ud574 DDL(CREATE, ALTER, DROP), \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \uc720\ud615 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\uc57d \uc870\uac74\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)\" \/>\n<meta property=\"og:description\" content=\"\ucd08\ubcf4\uc790\ub97c \uc704\ud574 DDL(CREATE, ALTER, DROP), \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \uc720\ud615 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\uc57d \uc870\uac74\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Bali Island Tekno\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-09T13:50:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-09T13:51:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Wilan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"Wilan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/\"},\"author\":{\"name\":\"Wilan\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\"},\"headline\":\"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)\",\"datePublished\":\"2026-05-09T13:50:59+00:00\",\"dateModified\":\"2026-05-09T13:51:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/\"},\"wordCount\":144,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DDL.webp\",\"articleSection\":[\"\ud504\ub85c\uadf8\ub798\ubc0d\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/\",\"name\":\"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DDL.webp\",\"datePublished\":\"2026-05-09T13:50:59+00:00\",\"dateModified\":\"2026-05-09T13:51:02+00:00\",\"description\":\"\ucd08\ubcf4\uc790\ub97c \uc704\ud574 DDL(CREATE, ALTER, DROP), \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \uc720\ud615 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\uc57d \uc870\uac74\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DDL.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DDL.webp\",\"width\":1920,\"height\":1080,\"caption\":\"DDL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/articles\\\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/\",\"name\":\"Bali Island Tekno\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/#organization\",\"name\":\"Bali Island Tekno\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"width\":512,\"height\":512,\"caption\":\"Bali Island Tekno\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/Wilanpedia\\\/61575048527927\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ko\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\",\"name\":\"Wilan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"caption\":\"Wilan\"},\"sameAs\":[\"https:\\\/\\\/tekno.bali-island.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)","description":"\ucd08\ubcf4\uc790\ub97c \uc704\ud574 DDL(CREATE, ALTER, DROP), \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \uc720\ud615 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\uc57d \uc870\uac74\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/","og_locale":"ko_KR","og_type":"article","og_title":"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)","og_description":"\ucd08\ubcf4\uc790\ub97c \uc704\ud574 DDL(CREATE, ALTER, DROP), \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \uc720\ud615 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\uc57d \uc870\uac74\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.","og_url":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/","og_site_name":"Bali Island Tekno","article_publisher":"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/","article_published_time":"2026-05-09T13:50:59+00:00","article_modified_time":"2026-05-09T13:51:02+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","type":"image\/webp"}],"author":"Wilan","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"Wilan","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"4\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/#article","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/"},"author":{"name":"Wilan","@id":"https:\/\/tekno.bali-island.com\/ko\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42"},"headline":"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)","datePublished":"2026-05-09T13:50:59+00:00","dateModified":"2026-05-09T13:51:02+00:00","mainEntityOfPage":{"@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/"},"wordCount":144,"commentCount":0,"publisher":{"@id":"https:\/\/tekno.bali-island.com\/ko\/#organization"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","articleSection":["\ud504\ub85c\uadf8\ub798\ubc0d"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/","url":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/","name":"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/#primaryimage"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","datePublished":"2026-05-09T13:50:59+00:00","dateModified":"2026-05-09T13:51:02+00:00","description":"\ucd08\ubcf4\uc790\ub97c \uc704\ud574 DDL(CREATE, ALTER, DROP), \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \uc720\ud615 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\uc57d \uc870\uac74\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/#primaryimage","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DDL.webp","width":1920,"height":1080,"caption":"DDL"},{"@type":"BreadcrumbList","@id":"https:\/\/tekno.bali-island.com\/ko\/articles\/ddl-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ed%82%a4-%eb%b0%8f-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tekno.bali-island.com\/ko\/"},{"@type":"ListItem","position":2,"name":"DDL, \ub370\uc774\ud130 \uc720\ud615, \ud0a4 \ubc0f \uc81c\uc57d \uc870\uac74 (MySQL)"}]},{"@type":"WebSite","@id":"https:\/\/tekno.bali-island.com\/ko\/#website","url":"https:\/\/tekno.bali-island.com\/ko\/","name":"Bali Island Tekno","description":"","publisher":{"@id":"https:\/\/tekno.bali-island.com\/ko\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tekno.bali-island.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/tekno.bali-island.com\/ko\/#organization","name":"Bali Island Tekno","url":"https:\/\/tekno.bali-island.com\/ko\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/tekno.bali-island.com\/ko\/#\/schema\/logo\/image\/","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","width":512,"height":512,"caption":"Bali Island Tekno"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ko\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/"]},{"@type":"Person","@id":"https:\/\/tekno.bali-island.com\/ko\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42","name":"Wilan","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","caption":"Wilan"},"sameAs":["https:\/\/tekno.bali-island.com"]}]}},"_links":{"self":[{"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/posts\/3022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/comments?post=3022"}],"version-history":[{"count":1,"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/posts\/3022\/revisions"}],"predecessor-version":[{"id":3023,"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/posts\/3022\/revisions\/3023"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/media\/3003"}],"wp:attachment":[{"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/media?parent=3022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/categories?post=3022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ko\/wp-json\/wp\/v2\/tags?post=3022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}