{"id":1050,"date":"2020-06-30T14:09:37","date_gmt":"2020-06-30T05:09:37","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=1050"},"modified":"2020-06-30T14:09:37","modified_gmt":"2020-06-30T05:09:37","slug":"mysql-%ec%bb%ac%eb%9f%bc-%ec%b6%94%ea%b0%80-%ec%82%ad%ec%a0%9c-%eb%b3%80%ea%b2%bd","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=1050","title":{"rendered":"MySQL \uceec\ub7fc \ucd94\uac00 \uc0ad\uc81c \ubcc0\uacbd"},"content":{"rendered":"

MySQL \uceec\ub7fc \ucd94\uac00 \uc0ad\uc81c \ubcc0\uacbd<\/h1>\n

MySQL \uc5d0\uc11c \uceec\ub7fc\uc744 \ucd94\uac00 \uc0ad\uc81c\ud558\uac70\ub098, \uceec\ub7fc\uba85\uc744 \uc218\uc815, \uceec\ub7fc\uc758 \uc21c\uc11c\ub97c \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n

\uceec\ub7fc \ucd94\uac00<\/h2>\n
ALTER TABLE tbl_user ADD level int DEFAULT 1;\nALTER TABLE tbl_user ADD COLUMN ranking INT(10) DEFAULT 0 AFTER `userid`;\nALTER TABLE tbl_user ADD COLUMN idx INT(10) DEFAULT 1 FIRST;<\/code><\/pre>\n
\uceec\ub7fc \uc0ad\uc81c<\/h2>\n
ALTER TABLE tbl_user DROP COLUMN level;<\/code><\/pre>\n
\uceec\ub7fc \ud0c0\uc785 \ubcc0\uacbd<\/h2>\n
ALTER TABLE tbl_user MODIFY email varchar(128);<\/code><\/pre>\n
\uceec\ub7fc \ub514\ud3f4\ud2b8\uac12 \ubcc0\uacbd<\/h2>\n
ALTER TABLE tbl_user ALTER COLUMN level SET DEFAULT 5;<\/code><\/pre>\n
\uceec\ub7fc \uc21c\uc11c \ubcc0\uacbd<\/h2>\n
ALTER TABLE tbl_user MODIFY nickname varchar(64) AFTER userid;<\/code><\/pre>\n
\uceec\ub7fc\uba85 \ubcc0\uacbd<\/h2>\n
ALTER TABLE tbl_user CHANGE nickname nick_name varchar(64);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
MySQL \uceec\ub7fc \ucd94\uac00 \uc0ad\uc81c \ubcc0\uacbd MySQL \uc5d0\uc11c \uceec\ub7fc\uc744 \ucd94\uac00 \uc0ad\uc81c\ud558\uac70\ub098, \uceec\ub7fc\uba85\uc744 \uc218\uc815, \uceec\ub7fc\uc758 \uc21c\uc11c\ub97c \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uceec\ub7fc \ucd94\uac00 ALTER TABLE tbl_user ADD level int DEFAULT 1; ALTER TABLE tbl_user ADD COLUMN ranking INT(10) DEFAULT 0 AFTER `userid`; ALTER TABLE tbl_user ADD COLUMN idx INT(10) DEFAULT 1 FIRST; \uceec\ub7fc \uc0ad\uc81c ALTER TABLE tbl_user DROP COLUMN\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-1050","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1050","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=1050"}],"version-history":[{"count":1,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1050\/revisions"}],"predecessor-version":[{"id":1051,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1050\/revisions\/1051"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}