{"id":1412,"date":"2023-07-18T06:41:07","date_gmt":"2023-07-17T21:41:07","guid":{"rendered":"https:\/\/pigletstory.co.kr\/697-2\/"},"modified":"2023-07-18T15:42:03","modified_gmt":"2023-07-18T06:42:03","slug":"697-2","status":"publish","type":"post","link":"https:\/\/pigletstory.co.kr\/?p=1412","title":{"rendered":"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd#"},"content":{"rendered":"
\n

\uceec\ub7fc<\/span> <\/span>\ucd94\uac00<\/span> (Add)<\/span><\/b><\/p>\n

ALTER TABLE table_name<\/span> ADD COLUMN ex_column<\/span> varchar(32) NOT NULL;<\/b><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\uceec\ub7fc<\/span> <\/span>\ubcc0\uacbd<\/span> (Modify)<\/span><\/b><\/p>\n

ALTER TABLE table_name<\/span> MODIFY COLUMN ex_column<\/span> varchar(16) NULL;<\/b><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\uceec\ub7fc<\/span> <\/span>\uc774\ub984\uae4c\uc9c0 \ubcc0\uacbd<\/span> (Change)<\/span><\/b><\/p>\n

ALTER TABLE table_name<\/span> CHANGE COLUMN ex_column ex_column2<\/span> varchar(16) NULL;<\/b><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\uceec\ub7fc<\/span> <\/span>\uc0ad\uc81c<\/span> (Drop)<\/span><\/b><\/p>\n

ALTER TABLE table_name<\/span> DROP COLUMN ex_column<\/span>;<\/b><\/p>\n

\u00a0<\/p>\n

\ud14c\uc774\ube14<\/span> <\/span>\uc774\ub984 \ubcc0\uacbd<\/span> (RENAME)<\/span><\/b><\/p>\n

ALTER TABLE table_name1<\/span> RENAME table_name2<\/span>;<\/b><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

\uceec\ub7fc \ucd94\uac00 (Add) ALTER TABLE table_name ADD COLUMN ex_column varchar(32) NOT NULL; \u00a0 \u00a0 \uceec\ub7fc \ubcc0\uacbd (Modify) ALTER TABLE table_name MODIFY COLUMN ex_column varchar(16) NULL; \u00a0 \u00a0 \uceec\ub7fc \uc774\ub984\uae4c\uc9c0 \ubcc0\uacbd (Change) ALTER TABLE table_name CHANGE COLUMN ex_column ex_column2 varchar(16) NULL; \u00a0 \u00a0 \uceec\ub7fc \uc0ad\uc81c (Drop) ALTER TABLE table_name DROP COLUMN ex_column; \u00a0 \ud14c\uc774\ube14 \uc774\ub984 \ubcc0\uacbd … \ub354 \uc77d\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6,7],"tags":[570,572,571,574,573],"class_list":["post-1412","post","type-post","status-publish","format-standard","hentry","category-linux---","category-mariadb","tag-mariadb","tag-mariadb-table-","tag-mysql-table-","tag-mysql-","tag-573"],"yoast_head":"\n# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd# - pigletstory \ube14\ub85c\uadf8<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pigletstory.co.kr\/?p=1412\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd# - pigletstory \ube14\ub85c\uadf8\" \/>\n<meta property=\"og:description\" content=\"\uceec\ub7fc \ucd94\uac00 (Add) ALTER TABLE table_name ADD COLUMN ex_column varchar(32) NOT NULL; \u00a0 \u00a0 \uceec\ub7fc \ubcc0\uacbd (Modify) ALTER TABLE table_name MODIFY COLUMN ex_column varchar(16) NULL; \u00a0 \u00a0 \uceec\ub7fc \uc774\ub984\uae4c\uc9c0 \ubcc0\uacbd (Change) ALTER TABLE table_name CHANGE COLUMN ex_column ex_column2 varchar(16) NULL; \u00a0 \u00a0 \uceec\ub7fc \uc0ad\uc81c (Drop) ALTER TABLE table_name DROP COLUMN ex_column; \u00a0 \ud14c\uc774\ube14 \uc774\ub984 \ubcc0\uacbd ... \ub354 \uc77d\uae30\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pigletstory.co.kr\/?p=1412\" \/>\n<meta property=\"og:site_name\" content=\"pigletstory \ube14\ub85c\uadf8\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T21:41:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-18T06:42:03+00:00\" \/>\n<meta name=\"author\" content=\"woo\" \/>\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=\"woo\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=1412#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=1412\"},\"author\":{\"name\":\"woo\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#\\\/schema\\\/person\\\/d7120640ee051cf680fd1c6a5208d620\"},\"headline\":\"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd#\",\"datePublished\":\"2023-07-17T21:41:07+00:00\",\"dateModified\":\"2023-07-18T06:42:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=1412\"},\"wordCount\":56,\"commentCount\":0,\"keywords\":[\"mariadb\",\"mariadb table \ubcc0\uacbd\",\"mysql table \ubcc0\uacbd\",\"mysql \ud14c\uc774\ube14\",\"\ub9c8\ub9ac\uc544\ub514\ube44\"],\"articleSection\":[\"Linux\",\"MariaDB\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pigletstory.co.kr\\\/?p=1412#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=1412\",\"url\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=1412\",\"name\":\"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd# - pigletstory \ube14\ub85c\uadf8\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#website\"},\"datePublished\":\"2023-07-17T21:41:07+00:00\",\"dateModified\":\"2023-07-18T06:42:03+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#\\\/schema\\\/person\\\/d7120640ee051cf680fd1c6a5208d620\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=1412#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pigletstory.co.kr\\\/?p=1412\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=1412#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pigletstory.co.kr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd#\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#website\",\"url\":\"https:\\\/\\\/pigletstory.co.kr\\\/\",\"name\":\"pigletstory \ube14\ub85c\uadf8\",\"description\":\"pigletstory\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pigletstory.co.kr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#\\\/schema\\\/person\\\/d7120640ee051cf680fd1c6a5208d620\",\"name\":\"woo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g\",\"caption\":\"woo\"},\"sameAs\":[\"http:\\\/\\\/129.154.62.45\"],\"url\":\"https:\\\/\\\/pigletstory.co.kr\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd# - pigletstory \ube14\ub85c\uadf8","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:\/\/pigletstory.co.kr\/?p=1412","og_locale":"ko_KR","og_type":"article","og_title":"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd# - pigletstory \ube14\ub85c\uadf8","og_description":"\uceec\ub7fc \ucd94\uac00 (Add) ALTER TABLE table_name ADD COLUMN ex_column varchar(32) NOT NULL; \u00a0 \u00a0 \uceec\ub7fc \ubcc0\uacbd (Modify) ALTER TABLE table_name MODIFY COLUMN ex_column varchar(16) NULL; \u00a0 \u00a0 \uceec\ub7fc \uc774\ub984\uae4c\uc9c0 \ubcc0\uacbd (Change) ALTER TABLE table_name CHANGE COLUMN ex_column ex_column2 varchar(16) NULL; \u00a0 \u00a0 \uceec\ub7fc \uc0ad\uc81c (Drop) ALTER TABLE table_name DROP COLUMN ex_column; \u00a0 \ud14c\uc774\ube14 \uc774\ub984 \ubcc0\uacbd ... \ub354 \uc77d\uae30","og_url":"https:\/\/pigletstory.co.kr\/?p=1412","og_site_name":"pigletstory \ube14\ub85c\uadf8","article_published_time":"2023-07-17T21:41:07+00:00","article_modified_time":"2023-07-18T06:42:03+00:00","author":"woo","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"woo"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pigletstory.co.kr\/?p=1412#article","isPartOf":{"@id":"https:\/\/pigletstory.co.kr\/?p=1412"},"author":{"name":"woo","@id":"https:\/\/pigletstory.co.kr\/#\/schema\/person\/d7120640ee051cf680fd1c6a5208d620"},"headline":"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd#","datePublished":"2023-07-17T21:41:07+00:00","dateModified":"2023-07-18T06:42:03+00:00","mainEntityOfPage":{"@id":"https:\/\/pigletstory.co.kr\/?p=1412"},"wordCount":56,"commentCount":0,"keywords":["mariadb","mariadb table \ubcc0\uacbd","mysql table \ubcc0\uacbd","mysql \ud14c\uc774\ube14","\ub9c8\ub9ac\uc544\ub514\ube44"],"articleSection":["Linux","MariaDB"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pigletstory.co.kr\/?p=1412#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pigletstory.co.kr\/?p=1412","url":"https:\/\/pigletstory.co.kr\/?p=1412","name":"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd# - pigletstory \ube14\ub85c\uadf8","isPartOf":{"@id":"https:\/\/pigletstory.co.kr\/#website"},"datePublished":"2023-07-17T21:41:07+00:00","dateModified":"2023-07-18T06:42:03+00:00","author":{"@id":"https:\/\/pigletstory.co.kr\/#\/schema\/person\/d7120640ee051cf680fd1c6a5208d620"},"breadcrumb":{"@id":"https:\/\/pigletstory.co.kr\/?p=1412#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pigletstory.co.kr\/?p=1412"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/pigletstory.co.kr\/?p=1412#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pigletstory.co.kr\/"},{"@type":"ListItem","position":2,"name":"# mysql table \uac12 \ubcc0\uacbd mariadb \ud14c\uc774\ube14 \uac12 \ubcc0\uacbd#"}]},{"@type":"WebSite","@id":"https:\/\/pigletstory.co.kr\/#website","url":"https:\/\/pigletstory.co.kr\/","name":"pigletstory \ube14\ub85c\uadf8","description":"pigletstory","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pigletstory.co.kr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/pigletstory.co.kr\/#\/schema\/person\/d7120640ee051cf680fd1c6a5208d620","name":"woo","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/secure.gravatar.com\/avatar\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g","caption":"woo"},"sameAs":["http:\/\/129.154.62.45"],"url":"https:\/\/pigletstory.co.kr\/?author=1"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1412"}],"version-history":[{"count":1,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1412\/revisions"}],"predecessor-version":[{"id":1413,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1412\/revisions\/1413"}],"wp:attachment":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}