{"id":1252,"date":"2013-04-30T06:54:04","date_gmt":"2013-04-30T06:54:04","guid":{"rendered":"http:\/\/brain.payzip.co.kr\/?p=1252"},"modified":"2013-04-30T06:54:04","modified_gmt":"2013-04-30T06:54:04","slug":"mysql-alter-table-%ea%b5%ac%eb%ac%b8-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=1252","title":{"rendered":"MySQL ALTER TABLE \uad6c\ubb38 \uc815\ub9ac"},"content":{"rendered":"

 <\/p>\n

\uceec\ub7fc \ucd94\uac00
\n<\/strong>ALTER TABLE <\ud14c\uc774\ube14\uba85>\u00a0ADD<\/strong>\u00a0<\uceec\ub7fc> <\ub370\uc774\ud130 \ud0c0\uc785>\u00a0AFTER<\/strong>\u00a0<\ud14c\uc774\ube0c\uba85><\/p>\n

\uceec\ub7fc\uba85 \ubcc0\uacbd, \ud0c0\uc785 \ubcc0\uacbd
\n<\/strong>ALTER TABLE <\ud14c\uc774\ube14\uba85>\u00a0CHANGE<\/strong>\u00a0<OLD \uceec\ub7fc> <NEW \uceec\ub7fc> <\ub370\uc774\ud130 \ud0c0\uc785><\/p>\n

\uceec\ub7fc \uc0ad\uc81c<\/strong>
\nALTER TABLE <\ud14c\uc774\ube14<\/span>\uba85>\u00a0DROP<\/strong>\u00a0<\uceec\ub7fc\uba85><\/p>\n

\uceec\ub7fc \ud0c0\uc785 \ubcc0\uacbd
\n<\/strong>ALTER TABLE <\ud14c\uc774\ube14\uba85>\u00a0MODIFY<\/strong>\u00a0<\uceec\ub7fc\uba85> <\ub370\uc774\ud130 \ud0c0\uc785><\/p>\n

 <\/p>\n

<\/div>\n

\ud14c\uc774\ube14\uba85 \uc218\uc815
\n<\/strong>ALTER TABLE <\ud14c\uc774\ube14\uba85>\u00a0\u00a0RENAME\u00a0<\/strong><NEW \ud14c\uc774\ube14\uba85><\/p>\n

 
\n\ucd9c\ucc98 –\u00a0http:\/\/baljack.tistory.com\/9
\n=========================================================================================<\/p>\n

\n

\ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uc0dd\uc131<\/p>\n

DROP TABLE test;
\nCREATE TABLE test (
\nid\u00a0\u00a0INTEGER,
\nage\u00a0\u00a0INTEGER,
\nname\u00a0\u00a0VARCHAR(50),
\njumin\u00a0VARCHAR(15),
\nPRIMARY KEY(id),
\nUNIQUE(age),
\nINDEX(name),
\nKEY(jumin),
\nINDEX(name, jumin)
\n);<\/p>\n

– INDEX\ub97c KEY\ub85c \ubc14\uafd4\ub3c4 \ub41c\ub2e4.
\n– INDEX(name, jumin) \uacfc INDEX(name), INDEX(jumin) \uc740 \ub2e4\ub984<\/p>\n

– [] \uc5d0 \ub4e4\uc5b4\uac00 \uc788\ub294 \ub0b4\uc6a9\uc740 \uc0dd\ub7b5 \uac00\ub2a5<\/p>\n

\u25b6 \ud14c\uc774\ube14 \uc18d\uc131 \ubcc0\uacbd
\n1. \ud544\ub4dc \ucd94\uac00
\n– ATLER TABLE \ud14c\uc774\ube14\uba85 ADD [COLUMN] \ucd94\uac00\ud560\ud544\ub4dc\uba85 \ud544\ub4dc\ud0c0\uc785 [FIRST | AFTER \ud544\ub4dc\uba85]
\n– ATLER TABLE \ud14c\uc774\ube14\uba85 ADD [COLUMN] (\ucd94\uac00\ud560\ud544\ub4dc\uba85 \ud544\ub4dc\ud0c0\uc785, …)<\/p>\n

 <\/p>\n

2. \ud544\ub4dc\uba85 \ubc0f \ud0c0\uc785 \ubcc0\uacbd
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 CHANGE [COLUMN] \uae30\uc874\ud544\ub4dc\uba85 \ubcc0\uacbd\ud560\ud544\ub4dc\uba85 \ubcc0\uacbd\ud560\ud544\ub4dc\ud0c0\uc785 [FIRST | AFTER \ud544\ub4dc\uba85]<\/p>\n

 <\/p>\n

3. \ud544\ub4dc \ud0c0\uc785 \ubcc0\uacbd
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 MODIFY [COLUMN] \uae30\uc874\ud544\ub4dc\uba85 \ubcc0\uacbd\ud560\ud544\ub4dc\uba85 [FIRST | AFTER \ud544\ub4dc\uba85]<\/p>\n

 <\/p>\n

4. \ud544\ub4dc \uc0ad\uc81c
\n– ATLER TABLE \ud14c\uc774\ube14\uba85 DROP [COLUMN] \uc81c\uac70\ud560\ud544\ub4dc\uba85<\/p>\n

 <\/p>\n

5. \ud544\ub4dc \ub514\ud3f4\ud2b8 \uc815\uc758
\n– ATLER TABLE \ud14c\uc774\ube14\uba85 ATLER [COLUMN] \ud544\ub4dc\uba85 {SET DEFAULT ‘XXX’ | DROP DEFAULT}<\/p>\n

 <\/p>\n

6. \ud14c\uc774\ube14\uba85 \ubcc0\uacbd
\n– ATLER TABLE \ud14c\uc774\ube14\uba85 RENAME \ubcc0\uacbd\ud560\ud14c\uc774\ube14\uba85<\/p>\n

 <\/p>\n

7. COMMENT \ucd94\uac00
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 COMMENT ‘XXX’
\n-> SHOW TABLE STATUS
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 MODIFY \ud544\ub4dc\uba85 \ud544\ub4dc\ud0c0\uc785 [DEFAULT ‘XXX’] COMMENT ‘YYY’;
\n-> SHOW CREATE TABLE \ud14c\uc774\ube14\uba85<\/p>\n

 <\/p>\n

\u25b6 \uc778\ub371\uc2a4 \uad00\ub828
\n1. \uc778\ub371\uc2a4 \uc0dd\uc131
\n– CREATE INDEX \uc778\ub371\uc2a4\uba85 ON \ud14c\uc774\ube14\uba85 (\ud544\ub4dc1, \ud544\ub4dc2, …)
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 ADD INDEX [\uc778\ub371\uc2a4\uba85] [\uc778\ub371\uc2a4\ud0c0\uc785] (\ud544\ub4dc1, \ud544\ub4dc2, …)
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 ADD [CONSTRAINT [\uc2ec\ubcfc]] PRIMARY KEY [\uc778\ub371\uc2a4\ud0c0\uc785] (\ud544\ub4dc1, \ud544\ub4dc2, …)<\/p>\n

– ALTER TABLE \ud14c\uc774\ube14\uba85 ADD [CONSTRAINT [\uc2ec\ubcfc]] FOREIGN KEY [\uc778\ub371\uc2a4\uba85] (\ud544\ub4dc1, \ud544\ub4dc2, …) [\ub808\ud37c\ub7f0\uc2a4\uc870\uac74]
\n– ALTER TABLE \ud14c\uc774\ube14\uba85\u00a0ADD [CONSTRAINT [\uc2ec\ubcfc]] UNIQUE [\uc778\ub371\uc2a4\uba85] [\uc778\ub371\uc2a4\ud0c0\uc785] (\ud544\ub4dc1, \ud544\ub4dc2, …)
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 ADD FULLTEXT [\uc778\ub371\uc2a4\uba85] (\ud544\ub4dc1, \ud544\ub4dc2, …)<\/p>\n

 <\/p>\n

2. \uc778\ub371\uc2a4 \ubcf4\uae30
\n– SHOW INDEX FROM \ud14c\uc774\ube14\uba85<\/p>\n

 <\/p>\n

3. \uc778\ub371\uc2a4 \uc0ad\uc81c
\n– DROP INDEX \uc778\ub371\uc2a4\uba85 ON \ud14c\uc774\ube14\uba85
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 DROP INDEX \uc778\ub371\uc2a4\uba85
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 DROP PRIMARY KEY
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 DROP FOREIGN KEY [fk_symbol]<\/p>\n

 <\/p>\n

4. \ud0a4 \ud65c\uc131\ud654
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 ENABLE KEYS
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 DISABLE KEYS<\/p>\n

 <\/p>\n

5. \uc815\ub82c
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 ORDER BY \ud544\ub4dc\uba85<\/p>\n

 <\/p>\n

6. \uce90\ub9ad\ud130 \uc14b
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 CONVER TO CHARACTER SET \uce90\ub9ad\ud130\uc14b
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 CHARACTER SET \uce90\ub9ad\ud130\uc14b<\/p>\n

 <\/p>\n

7. \ub370\uc774\ud130\ubca0\uc774\ud2b8 \uc5d4\uc9c4 \ubcc0\uacbd
\n– ALTER TABLE \ud14c\uc774\ube14\uba85 ENGINE={InnoDB | MyISAM}<\/p>\n

 <\/p>\n

\u25b6 \uc720\uc6a9 \uba85\ub839\uc5b4
\nHELP SHOW
\nHELP {SELECT | DELETE | UPDATE}
\nHELP ALTER
\nHELP ALTER {DATABASE | TABLE}<\/p>\n

SHOW PRIVILEGES
\nSHOW OPEN TABLES
\nSHOW TABLE STATUS<\/p>\n<\/div>\n

\ucd9c\ucc98 –\u00a0\u00a0http:\/\/blog.naver.com\/goddes4?Redirect=Log&logNo=30116416169<\/a><\/p>\n

==============================================================================================<\/p>\n

Alter\ubb38\uc744 \uc774\uc6a9\ud558\uba74 \ud14c\uc774\ube14\uc5d0 \uc5f4\uc744 \ucd94\uac00\ud558\ub294 \ub4f1 \uad6c\uc870\ub97c \ubcc0\uacbd\ud560 \uc218 \uc788\ub2e4.<\/p>\n

Alter\ubb38\uc5d0\ub294 \uc5ec\ub7ec\uac00\uc9c0 \uc5f0\uc0b0\uc790\uac00 \uc788\ub2e4.
\n– Add : \ud14c\uc774\ube14\uc5d0 \uc5f4\uc744 \ucd94\uac00\ud55c\ub2e4.
\n– Rename to : \ud14c\uc774\ube14\uc758 \uc774\ub984\uc744 \ubc14\uafbc\ub2e4.
\n– Change : \uae30\uc874 \uc5f4\uc758 \uc774\ub984\uacfc \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ubc14\uafbc\ub2e4.
\n– Modify : \uae30\uc874 \uc5f4\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc774\ub098 \uc704\uce58\ub97c \ubcc0\uacbd\ud55c\ub2e4.
\n– Drop : \ud14c\uc774\ube14\uc758 \uc5f4\uc744 \uc81c\uac70\ud55c\ub2e4.<\/p>\n

Add \uc5f0\uc0b0\uc790<\/strong>
\n– \ud14c\uc774\ube14\uc5d0 \uc5f4\uc744 \ucd94\uac00\ud560 \uc218 \uc788\ub2e4.<\/p>\n

mysql> alter table \ud14c\uc774\ube14\uba85 add column \ucd94\uac00\ud558\ub824\ub294 \uceec\ub7fc\uba85 first(\uc704\uce58);<\/p>\n

\uc608) \uae30\uc874 \ud14c\uc774\ube14\uc5d0 \uc81c 1\uc815\uaddc\ud654\ub97c \uc801\uc6a9\ud558\ub824\uace0 \ud55c\ub2e4.(\uae30\ubcf8\ud0a4 \uceec\ub7fc \uc801\uc6a9)<\/p>\n

mysql> alter table \ud14c\uc774\ube14\uba85 add cloumn \uceec\ub7fc\uba85\u00a0int<\/span>\u00a0not null<\/span>\u00a0auto_increment\u00a0first<\/span>, \u00a0\/\/\uccab\ubc88\uc7ac \uceec\ub7fc\uc704\uce58\uc5d0 \ucd94\uac00
\nadd primary key (\uceec\ub7fc\uba85); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/\/ (\uceec\ub7fc\uba85)\uc744 \uae30\ubcf8\ud0a4\ub85c \uc124\uc815<\/p>\n

* first\ub294 \uccab\ubc88\uc9f8 \uceec\ub7fc \uc704\uce58\uc5d0 \uc9d1\uc5b4 \ub123\uc73c\ub77c\ub294 \ud0a4\uc6cc\ub4dc\uc774\ub2e4.<\/p>\n

* first\uc790\ub9ac\uc5d0\ub294 \uc5ec\ub7ec \ud0a4\uc6cc\ub4dc\uac00 \ub4e4\uc5b4\uac08 \uc218 \uc788\ub2e4.
\n– first, second, third, … , last, before, after \ub4f1\ub4f1<\/p>\n

* before\uacfc after \uc0ac\uc6a9\ubc29\ubc95<\/p>\n

mysql> alter table my_contacts add column phone varchar(10)\u00a0before<\/strong>\u00a0last_name;<\/p>\n

my_contacts<\/div>\n\n\n\n
\u00a0contact_id<\/td>\nphone\u00a0<\/strong><\/td>\nlast_name<\/td>\nfirst_name<\/td>\nemail<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

mysql> alter table my_contacts add cloumn phone varchar(10) after last_name;<\/p>\n

\nmy_contacts<\/div>\n\n\n\n
\u00a0contact_id<\/td>\nlast_name<\/td>\nphone<\/strong><\/td>\nfirst_name<\/td>\nemail<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Alter\ubb38\uc758 Rename to \uc5f0\uc0b0\uc790\ub97c \uc774\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\uc758 \uc774\ub984\uc744 \ubcc0\uacbd\ud560 \uc218 \uc788\ub2e4.<\/p>\n

mysql> alter table \uae30\uc874 \ud14c\uc774\ube14\uba85\u00a0rename to<\/strong>\u00a0\uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14\uba85;<\/p>\n

Alter\ubb38\uc758 Change \uc5f0\uc0b0\uc790\ub97c \uc774\uc6a9\ud558\uba74 \uae30\uc874 \uc5f4\uc758 \uc774\ub984\uacfc \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ubc14\uafc0 \uc218 \uc788\ub2e4.<\/p>\n

mysql> alter table \ud14c\uc774\ube14\uba85\u00a0change<\/strong>\u00a0column\u00a0\uceec\ub7fc\uba85<\/span>\u00a0\uc0c8\ub85c\uc6b4 \uceec\ub7fc\uba85<\/span>\u00a0\uc18d\uc131<\/span>;<\/p>\n

\uc608) project_list \ud14c\uc774\ube14\uc758 ‘number<\/span>‘\ub77c\ub294 \uc5f4\uc758 \uc774\ub984\uc744 ‘proj_id<\/span>‘\ub85c \uace0\uce5c\ud6c4 \uc81c 1\uc815\uaddc\ud654\ub97c \uc801\uc6a9\ud55c\ub2e4.<\/p>\n

mysql> alter table project_list\u00a0change<\/strong>\u00a0column\u00a0number<\/span>\u00a0proj_id<\/span>\u00a0int<\/span>\u00a0not null<\/span>\u00a0auto_increment<\/span>, \u00a0\/\/ \ubc11\uc904 : \uc18d\uc131
\nadd<\/strong>\u00a0primary key (proj_id); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/\/ \uae30\ubcf8\ud0a4 \uc801\uc6a9<\/p>\n

\ud55c\uaebc\ubc88\uc5d0 \uc5ec\ub7ec\uac1c\uc758 \uceec\ub7fc\uc744 \uc218\uc815\ud560 \uc218 \uc788\ub2e4.<\/p>\n

\uc608) project_list \ud14c\uc774\ube14\uc758 \uceec\ub7fc ‘descriptionofproj<\/span>‘ \ub97c ‘proj_desc<\/span>‘ \uc774\ub984\uc73c\ub85c \ub370\uc774\ud130 \ud0c0\uc785\uc744 varchar(100)\uc73c\ub85c,
\n\uceec\ub7fc ‘contractoronjob<\/span>‘\ub97c ‘con_name<\/span>‘ \uc774\ub984\uc73c\ub85c \ub370\uc774\ud130\ud0c0\uc785\uc744 varchar(30)\uc73c\ub85c \uc218\uc815\ud55c\ub2e4.<\/p>\n

mysql> alter table project_list\u00a0change<\/strong>\u00a0column\u00a0descriptionofproj<\/span>\u00a0proj_desc<\/span>\u00a0varchar(100),
\nchange<\/strong>\u00a0column\u00a0contractoronjob<\/span>\u00a0con_name<\/span>\u00a0varchar(30);<\/p>\n

* \ub370\uc774\ud130\ud0c0\uc785\ub9cc \uc218\uc815\ud560 \uacbd\uc6b0 Modify\ub97c \ud65c\uc6a9\ud560 \uac83!
\nhttp:\/\/warmz.tistory.com\/247<\/a><\/p>\n

\uc608) projekts\ub77c\ub294 \ud14c\uc774\ube14 \uc774\ub984\uc744 project_list\ub85c \ubc14\uafb8\ub824\uace0 \ud55c\ub2e4.<\/p>\n

myslq> alter table projekts\u00a0rename to<\/strong>\u00a0project_list;<\/p>\n

Alter\ubb38\uc758 Modify \uc5f0\uc0b0\uc790\ub97c \uc774\uc6a9\ud558\uba74 \uceec\ub7fc\uc758 \uc704\uce58\ub098 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ubcc0\uacbd\ud560 \uc218 \uc788\ub2e4.<\/p>\n

mysql> alter table \ud14c\uc774\ube14\uba85\u00a0modify<\/strong>\u00a0column \uceec\ub7fc\uba85\u00a0\uc704\uce58 \ud639\uc740 \ub370\uc774\ud130 \ud0c0\uc785<\/span>;<\/p>\n

\uc608) \uae30\uc874\uc758 \uceec\ub7fc\uba85\uc740 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud558\ub418 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ubc14\uafb8\ub824\uace0 \ud55c\ub2e4.<\/p>\n

mysql> alter table \ud14c\uc774\ube14\uba85\u00a0modify<\/strong>\u00a0column \uceec\ub7fc\uba85\u00a0varchar(120)<\/span>;<\/p>\n

\uc5f4\uc758 \uc21c\uc11c\ub97c \ubc14\uafb8\ub824\uba74?<\/strong>
\n– \ud14c\uc774\ube14\uc774 \ub9cc\ub4e4\uc5b4\uc9c4 \ud6c4\uc758 \uc5f4\uc758 \uc21c\uc11c\ub97c \ubc14\uafb8\ub294 \uac83\uc740 \ubd88\uac00\ub2a5\ud558\ub2e4.
\n– \ud55c\uac00\uc9c0 \ubc29\ubc95\uc740 \uc0c8\ub85c\uc6b4 \uc5f4\uc744 \uc6d0\ud558\ub294 \uc704\uce58\uc5d0 \ucd94\uac00\ud558\uace0 \uc608\uc804 \uc5f4\uc744 \uc0ad\uc81c\ud558\ub294 \uac83\uc774\ub2e4.
\n– \ub610\ub2e4\ub978 \ubc29\ubc95\uc740 \ucffc\ub9ac \uacb0\uacfc \ucd9c\ub825\uc2dc \uc5f4\uc774 \ud45c\uc2dc\ub418\ub294 \uc21c\uc11c\ub97c \uc815\ud574\uc8fc\ub294 \uac83\uc774\ub2e4.<\/p>\n

* \ucffc\ub9ac \uacb0\uacfc \ud45c\uc2dc\ub418\ub294 \uc5f4\uc758 \uc21c\uc11c\ub97c \uc815\ud574\uc8fc\ub294 \ubc29\ubc95<\/p>\n

mysql> select column3, column1 from \ud14c\uc774\ube14\uba85;<\/p>\n

\ub610\ub294<\/p>\n

select column1, column3 from \ud14c\uc774\ube14\uba85;<\/p>\n

Alter\ubb38\uc5d0\uc11c Drop \uc5f0\uc0b0\uc790\ub97c \uc774\uc6a9\ud558\uba74 \ud2b9\uc815 \uceec\ub7fc\uc744 \uc0ad\uc81c\ud560 \uc218 \uc788\ub2e4.<\/p>\n

mysql> alter table \ud14c\uc774\ube14\uba85 drop \uceec\ub7fc\uba85;<\/p>\n

* \uceec\ub7fc\uc744 \uc0ad\uc81c\ud558\uba74 \uadf8 \uc548\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub358 \ubaa8\ub4e0 \ub370\uc774\ud130\ub294 \uc0ac\ub77c\uc9c0\ubbc0\ub85c \uc870\uc2ec\ud560 \uac83!<\/p>\n

\ucd9c\ucc98 –\u00a0http:\/\/linuxism.tistory.com\/425<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

  \uceec\ub7fc \ucd94\uac00 ALTER TABLE <\ud14c\uc774\ube14\uba85>\u00a0ADD\u00a0<\uceec\ub7fc> <\ub370\uc774\ud130 \ud0c0\uc785>\u00a0AFTER\u00a0<\ud14c\uc774\ube0c\uba85> \uceec\ub7fc\uba85 \ubcc0\uacbd, \ud0c0\uc785 \ubcc0\uacbd ALTER TABLE <\ud14c\uc774\ube14\uba85>\u00a0CHANGE\u00a0<OLD \uceec\ub7fc> <NEW \uceec\ub7fc> <\ub370\uc774\ud130 \ud0c0\uc785> \uceec\ub7fc \uc0ad\uc81c ALTER TABLE <\ud14c\uc774\ube14\uba85>\u00a0DROP\u00a0<\uceec\ub7fc\uba85> \uceec\ub7fc \ud0c0\uc785 \ubcc0\uacbd ALTER TABLE… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1252"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1252"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1252\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}