\uae30\ubcf8\uc801\uc73c\ub85c \uc9c0\uc6d0\ub418\uc9c0 \uc54a\ub294 \uae30\ub2a5\uc774\ub2e4. (Maria DB 10.219 \uc774\ud6c4\ub294 \uc9c0\uc6d0)<\/p>\n
\uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 \ud504\ub85c\uc2dc\uc800\ub97c \uc0dd\uc131\ud574\uc57c \ud55c\ub2e4.<\/p>\n
MySQL – ADD COLUMN IF NOT EXISTS \uae30\ubcf8\uc801\uc73c\ub85c \uc9c0\uc6d0\ub418\uc9c0 \uc54a\ub294 \uae30\ub2a5\uc774\ub2e4. (Maria DB 10.219 \uc774\ud6c4\ub294 \uc9c0\uc6d0) \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 \ud504\ub85c\uc2dc\uc800\ub97c \uc0dd\uc131\ud574\uc57c \ud55c\ub2e4. sql_notes \ub294 \ud504\ub85c\uc2dc\uc800\uac00 \uc5c6\ub2e4\ub294 \uacbd\uace0\ub97c \ube44\ud65c\uc131\ud654\uc2dc\ucf1c\uc900\ub2e4. DELIMITER $$ SET sql_notes = 0$$ DROP PROCEDURE IF EXISTS AddColumn$$ SET sql_notes = 1$$ CREATE PROCEDURE AddColumn( IN dbName TINYTEXT, IN tableName TINYTEXT, IN fieldName TINYTEXT, IN\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[],"class_list":["post-10033","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/10033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10033"}],"version-history":[{"count":1,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/10033\/revisions"}],"predecessor-version":[{"id":10034,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/10033\/revisions\/10034"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}sql_notes<\/code> \ub294 \ud504\ub85c\uc2dc\uc800\uac00 \uc5c6\ub2e4\ub294 \uacbd\uace0\ub97c \ube44\ud65c\uc131\ud654\uc2dc\ucf1c\uc900\ub2e4.<\/p>\nDELIMITER $$\n\nSET sql_notes = 0$$\nDROP PROCEDURE IF EXISTS AddColumn$$\nSET sql_notes = 1$$\n\nCREATE PROCEDURE AddColumn(\n IN dbName TINYTEXT,\n IN tableName TINYTEXT,\n IN fieldName TINYTEXT,\n IN fieldDef TEXT)\nBEGIN\n IF NOT EXISTS (\n SELECT * FROM INFORMATION_SCHEMA.COLUMNS\n WHERE COLUMN_NAME=fieldName\n and TABLE_NAME=tableName\n and TABLE_SCHEMA=dbName\n )\n THEN\n SET @ddl=CONCAT('ALTER TABLE `',dbName,'`.`',tableName,\n '` ADD COLUMN `',fieldName,'` ',fieldDef);\n PREPARE stmt FROM @ddl;\n EXECUTE stmt;\n END IF;\nEND$$\n\nDELIMITER ;\n\nCALL AddColumn('mydb', 'mytable', 'myfield', 'DECIMAL(18,0)');<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"