{"id":1605,"date":"2020-11-22T19:59:02","date_gmt":"2020-11-22T11:59:02","guid":{"rendered":"https:\/\/www.yusian.com\/blog\/?p=1605"},"modified":"2020-11-24T21:12:25","modified_gmt":"2020-11-24T13:12:25","slug":"%e5%b8%b8%e7%94%a8%e7%9a%84sql%e8%af%ad%e5%8f%a5%e6%b1%87%e6%80%bb","status":"publish","type":"post","link":"https:\/\/www.yusian.com\/blog\/database\/2020\/11\/22\/1959021605.html","title":{"rendered":"\u5e38\u7528\u7684SQL\u8bed\u53e5\u6c47\u603b"},"content":{"rendered":"

1\u3001DDL: \u6570\u636e\u5b9a\u4e49\u8bed\u53e5\uff0c\u64cd\u4f5c\u5e93\u6216\u8868<\/h2>\n
## \u5e93\u64cd\u4f5c\nSHOW DATABASES;-- \u67e5\u770b\u6570\u636e\u5e93\n\nCREATE DATABASE db;-- \u521b\u5efa\u6570\u636e\u5e93\n\nUSE db;-- \u4f7f\u7528\/\u5207\u6362\u6570\u636e\u5e93\n\nSELECT DATABASE ();-- \u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\n\nDROP DATABASE db;-- \u5220\u9664\u6570\u636e\u5e93\n\n## \u8868\u64cd\u4f5c\nUSE db1;-- \u5207\u6362\u6570\u636e\u5e93\n\nSHOW TABLES;-- \u67e5\u770b\u6240\u6709\u8868\n\nCREATE TABLE t_demo (-- \u521b\u5efa\u6570\u636e\u5e93\n    id INT PRIMARY KEY auto_increment,-- \u6307\u5b9a\u8be5\u5b57\u6bb5\u4e3a\u4e3b\u952e\uff0c\u81ea\u589e\u957f\n    username VARCHAR (32),-- \u5b57\u7b26\u957f\u5ea6\u4e3a32\u4e2a\u5b57\u8282\n    update_time TIMESTAMP-- \u65f6\u95f4\u6233\u7c7b\u578b\uff0c\u4e3a\u7a7a\u5219\u81ea\u52a8\u586b\u5145\u4e3a\u5f53\u524d\u65f6\u95f4\n) CHARACTER SET utf8mb4;-- \u6307\u5b9a\u5b57\u7b26\u96c6\u7684utf8mb4\n\nCREATE TABLE t_demo_copy LIKE t_demo;-- \u590d\u5236\u8868\n\nSHOW CREATE TABLE t_demo;-- \u67e5\u770b\u5b57\u7b26\u96c6\u6216\u521b\u5efa\u8868\u8bed\u53e5\n\nDESC t_demo;-- \u67e5\u770b\u8868\u5b57\u6bb5\u4fe1\u606f\n\nALTER TABLE t_demo ADD sex VARCHAR (3) AFTER username;-- \u65b0\u589e\u5b57\u6bb5\uff0cafter\u7528\u4e8e\u6307\u5b9a\u65b0\u5b57\u6bb5\u4f4d\u7f6e\n\nALTER TABLE t_demo CHANGE sex gender VARCHAR (3);-- \u4fee\u6539\u67d0\u4e2a\u5b57\u6bb5\u7684\u5c5e\u6027(\u540d\u79f0\u3001\u6570\u636e\u7c7b\u578b\u3001\u5b57\u7b26\u96c6\u7b49)\n\nALTER TABLE t_demo MODIFY gender VARCHAR (3) DEFAULT '\u7537';-- modify\u4e5f\u53ef\u4ee5\u7528\u6765\u4fee\u6539\u5b57\u6bb5\u5c5e\u6027\n\nALTER TABLE t_demo DROP gender;-- \u5220\u9664\u67d0\u4e2a\u5b57\u6bb5\n\nTRUNCATE TABLE t_demo;-- \u6e05\u7a7a\u6574\u4e2a\u8868\u7684\u6570\u636e\n\nDROP TABLE t_demo_copy;-- \u5220\u9664\u8868\n\n<\/code><\/pre>\n
<\/p>\n
2\u3001DML: \u6570\u636e\u64cd\u4f5c\u8bed\u53e5\uff0c\u64cd\u4f5c\u6570\u636e<\/h2>\n
INSERT INTO stu (username,age,sex,address) VALUES ('\u90d1\u516b',22,'\u7537','\u5317\u4eac');-- \u6309\u6307\u5b9a\u5b57\u6bb5\u63d2\u5165\u4e00\u6761\u6570\u636e\n\nINSERT INTO stu VALUES (6,'\u94b1\u591a\u591a',40,'\u7537','\u676d\u5dde',99,23);-- \u5982\u679c\u4e0d\u6307\u5b9a\u5b57\u6bb5\u5219\u9700\u8981\u5168\u5b57\u6bb5\u503c\n\nDELETE FROM stu WHERE id=11;-- \u5220\u9664\u67d0\u6761\u6570\u636e\uff0c\u5982\u679c\u540e\u9762\u6ca1\u6709\u6761\u4ef6\u8bed\u53e5\u5219\u4f1a\u5220\u9664\u67d0\u4e2a\u6570\u636e\u8868\u6240\u6709\u6570\u636e\n\nUPDATE stu SET username='\u94b1\u516b' WHERE id=6;-- \u4fee\u6539\u67d0\u6761\u8bb0\u5f55\u7684\u5b57\u6bb5\u503c\uff0c\u5982\u679c\u6ca1\u6709\u6307\u5b9a\u6761\u4ef6\u8bed\u53e5\u5219\u4f1a\u66f4\u65b0\u6574\u4e2a\u8868\u7684\u6240\u6709\u8bb0\u5f55\n\n<\/code><\/pre>\n
3\u3001DQL: \u6570\u636e\u67e5\u8be2\u8bed\u53e5\uff0c\u67e5\u8be2\u6570\u636e<\/h2>\n
3.1 \u6761\u4ef6\u67e5\u8be2<\/h3>\n
SELECT*FROM stu;-- \u67e5\u8be2\u67d0\u4e2a\u8868\u7684\u6240\u6709\u6570\u636e\n\nSELECT username,address FROM stu;-- \u67e5\u8be2\u6307\u5b9a\u5b57\u6bb5\u7684\u5185\u5bb9\n\nSELECT DISTINCT address FROM stu;-- distinct\u8868\u793a\u53bb\u91cd\uff0c\u5c06\u67e5\u8be2\u51fa\u6765\u7684\u5185\u5bb9\u53bb\u9664\u91cd\u590d\u7ed3\u679c\n\nSELECT username,(math+english) FROM stu;-- \u67e5\u8be2\u8bed\u53e5\u4e2d\u652f\u6301\u7b80\u5355\u7684\u8ba1\u7b97\n\nSELECT username AS \u59d3\u540d,(math+english) \u603b\u5206 FROM stu;-- \u67e5\u8be2\u5b57\u6bb5\u652f\u6301\u8bbe\u7f6e\u522b\u540d\n\nSELECT*FROM stu WHERE math IS NULL;-- \u67e5\u8be2\u4e3anull\u7684\u503c\u4e0d\u80fd\u7528=\u53f7\u5339\u914d\uff0c\u9700\u8981\u4f7f\u7528is null\u8bed\u53e5\n\nSELECT*FROM stu WHERE math> 70;-- \u6761\u4ef6\u67e5\u8be2\uff0c\u5927\u4e8e\n\nSELECT*FROM stu WHERE sex !='\u7537';-- \u6761\u4ef6\u67e5\u8be2\u4e0d\u7b49\u4e8e\uff0c\u8fd8\u53ef\u4ee5\u7528<>\u8868\u793a\n\nSELECT*FROM stu WHERE math BETWEEN 60 AND 80;-- \u533a\u95f4\u6761\u4ef6\u53ef\u4ee5\u4f7f\u7528between...and...\u7c7b\u4f3c\u903b\u8f91\u4e0e\n\nselect * from stu where age in (19,29,39);-- \u96c6\u5408\u6761\u4ef6\u67e5\u8be2\uff0c\u7c7b\u4f3c\u903b\u8f91\u6216\n\nSELECT*FROM stu WHERE username LIKE '\u94b1%';-- \u6a21\u7cca\u67e5\u8be2%\u4ee3\u8868\u4efb\u610f\u591a\u4e2a\u5b57\u7b26\n\nSELECT*FROM stu WHERE username LIKE '\u94b1_';-- \u6a21\u7cca\u67e5\u8be2_\u8868\u793a\u5355\u4e2a\u5b57\u7b26(\u4ee5\u5f53\u524d\u5b57\u7b26\u96c6\u4e3a\u51c6)\n<\/code><\/pre>\n
3.2 \u6392\u5e8f<\/h3>\n
SELECT*FROM stu ORDER BY IFNULL(math,85) ASC;-- \u6839\u636emath\u7684\u5347\u5e8f\u6392\u5e8f\uff0c\u9ed8\u8ba4\u662fASC\u5347\u5e8f\uff0c\u53ef\u4ee5\u4e3anull\u6307\u5b9a\u6570\u503c\u53c2\u4e0e\u6392\u5e8f\n\nSELECT*FROM stu ORDER BY age DESC;-- \u6309\u7167\u5e74\u9f84\u964d\u5e8f\u8f93\u51fa\n\nSELECT*FROM stu ORDER BY english ASC,age DESC;-- \u591a\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u5148\u6309\u82f1\u8bed\u6210\u7ee9\u6b63\u5e8f\uff0c\u6210\u7ee9\u76f8\u540c\u7684\u518d\u6309\u5e74\u9f84\u5012\u5e8f\n<\/code><\/pre>\n
3.3 \u805a\u5408<\/h3>\n
SELECT count(username) AS \u4eba\u6570 FROM stu;-- \u7edf\u8ba1username\u8fd9\u4e2a\u5b57\u6bb5\u503c\u7684\u4e2a\u6570(\u6392\u9664null\u503c);\n\nSELECT avg(math),max(math),min(math),sum(math) FROM stu;-- \u7edf\u8ba1\u5e73\u5747\u503c\u3001\u6700\u5927\u503c\u3001\u6700\u5c0f\u503c\u3001\u603b\u5206\u503c(\u6392\u9664null\u503c)\n<\/code><\/pre>\n
3.4 \u5206\u7ec4<\/h3>\n
SELECT sex,count(sex) AS \u4eba\u6570,avg(math),avg(english) FROM stu GROUP BY sex;-- \u5206\u7ec4\u67e5\u8be2\u53ea\u80fd\u662f\u5206\u7ec4\u7684\u5b57\u6bb5\u6216\u805a\u5408\u6570\u636e\n\n-- where\u4e0ehaving\u7684\u533a\u522b\uff1a\n-- 1\u3001where\u5728\u5206\u7ec4\u4e4b\u524d\uff0chaving\u5728\u5206\u7ec4\u4e4b\u540e\n-- 2\u3001where\u4e0d\u80fd\u4f7f\u7528\u5728\u805a\u5408\u7684\u60c5\u51b5\u4e0b\uff0chaving\u53ef\u4ee5\nSELECT sex,count(sex),avg(math) FROM stu WHERE sex='\u7537' GROUP BY sex;-- \u5206\u7ec4\u540e\u7684\u7b5b\u9009\u53ea\u80fd\u4f7f\u7528having\u4e0d\u80fd\u4f7f\u7528where\n\nSELECT sex,count(sex) \u4eba\u6570,avg(math) FROM stu GROUP BY sex HAVING \u4eba\u6570> 3;-- \u5206\u7ec4\u4e4b\u540e\u4f7f\u7528having\u7b5b\u9009\uff0c\u53ef\u7b5b\u9009\u805a\u5408\u5b57\u6bb5\n\nSELECT sex,count(sex) \u4eba\u6570,max(math) FROM stu GROUP BY sex HAVING \u4eba\u6570> 3 ORDER BY count(sex) DESC;-- \u5206\u7ec4\u67e5\u8be2\u52a0\u6392\u5e8f\n<\/code><\/pre>\n
3.5 \u5206\u9875<\/h3>\n
SELECT*FROM stu LIMIT 6,3;-- \u4ece\u7b2c7\u6761\u5f00\u59cb\u540e3\u6761\u6570\u636e\n<\/code><\/pre>\n
3.6 \u7ea6\u675f<\/h3>\n
# \u975e\u7a7aNOT NULL\nCREATE TABLE stu ( \n    id INT, \n    username VARCHAR ( 32 ) NOT NULL -- \u521b\u5efa\u8868\u65f6\u8bbe\u7f6e\u975e\u7a7a\n);\n\nALTER TABLE stu MODIFY username VARCHAR (32);-- \u4f7f\u7528modify\u89e3\u9664\u6216\u8bbe\u7f6e\u975e\u7a7a\u9650\u5236\n\nALTER TABLE stu CHANGE username username VARCHAR (32) NOT NULL;-- \u4f7f\u7528change\u540c\u6837\u53ef\u4ee5\u8bbe\u7f6e\u6216\u89e3\u9664\u975e\u7a7a\u9650\u5236\n\n# \u552f\u4e00\u7ea6\u675f UNIQUE\nCREATE TABLE stu ( \n    id INT, \n    username VARCHAR ( 32 ), \n    mobile VARCHAR ( 11 ) UNIQUE -- \u521b\u5efa\u8868\u65f6\u8bbe\u7f6e\u552f\u4e00\u952e\n);\nALTER TABLE stu DROP INDEX mobile;-- \u5220\u9664\u67d0\u5b57\u6bb5\u7684\u641c\u7d22\u5373\u4e3a\u53d6\u6d88\u552f\u4e00\u7ea6\u675f\n\nALTER TABLE stu MODIFY mobile VARCHAR (11) UNIQUE;-- \u4f7f\u7528modify\u6216change\u90fd\u53ef\u4ee5\u7ed9\u5b57\u6bb5\u6dfb\u52a0\u552f\u4e00\u6027\u7ea6\u675f\uff0c\u4f46\u524d\u63d0\u662f\u5f53\u524d\u8868\u4e2d\u8be5\u5b57\u6bb5\u4e0d\u5b58\u5728\u91cd\u590d\u9879\n\n# \u4e3b\u952ePRIMARY KEY\n\nCREATE TABLE stu (\n    id INT PRIMARY KEY,-- \u521b\u5efa\u8868\u65f6\u6307\u5b9a\u4e3b\u952e\n    username VARCHAR ( 32 ) \n);\n\nALTER TABLE stu DROP PRIMARY KEY;-- \u5220\u9664\u4e3b\u952e\n\nALTER TABLE stu MODIFY id INT PRIMARY KEY;-- \u8bbe\u7f6e\u4e3b\u952e\u53ef\u4f7f\u7528modify\u6216change\u64cd\u4f5c\n\nALTER TABLE stu MODIFY id INT auto_increment;-- \u8bbe\u7f6e\u5b57\u6bb5\u503c\u81ea\u589e\u957f\uff0c\u53ef\u4ee5\u4f7f\u7528modify\u6216change\uff0c\u4e0d\u7528\u5173\u5fc3\u4e3b\u952e\uff0c\u5426\u5219\u4f1a\u62a5\u9519\n\nALTER TABLE stu MODIFY id INT;-- \u53bb\u6389\u81ea\u589e\u957f\u4e5f\u4e00\u6837\uff0c\u53ef\u4ee5\u4f7f\u7528modify\u6216change\uff0c\u4f46\u4e0d\u80fd\u5e26\u4e3b\u952e\u5c5e\u6027\n\nALTER TABLE stu ADD PRIMARY KEY (id);-- \u8bbe\u7f6e\u4e3b\u952e\u7684\u53e6\u5916\u4e00\u79cd\u65b9\u5f0f\n\nALTER TABLE stu ADD PRIMARY KEY (id,username);-- \u8bbe\u7f6e\u8054\u5408\u4e3b\u952e\n# \u5916\u952e\n\nCREATE TABLE department (-- \u90e8\u95e8\u4fe1\u606f\u8868\n    id INT PRIMARY KEY auto_increment,\n    dep_name VARCHAR ( 20 ),\n    dep_location VARCHAR ( 20 ) \n) CHARACTER SET utf8mb4;\n\nCREATE TABLE employee (-- \u5458\u5de5\u4fe1\u606f\u8868\n    id INT PRIMARY KEY auto_increment,\n    username VARCHAR ( 32 ),\n    age INT,\n    dept_id INT,\n    CONSTRAINT emp_dept_fk FOREIGN KEY ( dept_id ) REFERENCES department ( id ) -- \u7ed9\u8868\u6dfb\u52a0\u5916\u952e\uff0c\u5c06dept_id\u4e0e\u8868department\u7684id\u76f8\u5173\u8054\n) CHARACTER SET utf8mb4;\n\nALTER TABLE employee DROP FOREIGN KEY emp_dept_fk;-- \u5220\u9664\u5916\u952e\n\nALTER TABLE employee ADD CONSTRAINT emp_dept_fk FOREIGN KEY (dept_id) REFERENCES department (id);-- \u6dfb\u52a0\u5916\u952e\n\n-- \u6dfb\u52a0\u6570\u636e\nINSERT INTO department VALUES (1,'\u7814\u53d1\u90e8','\u5e7f\u5dde');--\nINSERT INTO department VALUES (2,'\u9500\u552e\u90e8','\u6df1\u5733');--\nINSERT INTO employee VALUES (1,'\u5f20\u4e09',29,1);--\nINSERT INTO employee VALUES (2,'\u674e\u56db',29,1);--\nINSERT INTO employee VALUES (3,'\u738b\u4e94',29,1);--\nINSERT INTO employee VALUES (4,'\u8d75\u516d',29,2);--\nINSERT INTO employee VALUES (5,'\u7530\u4e03',29,2);--\nINSERT INTO employee VALUES (6,'\u94b1\u516b',29,2);--\n\nALTER TABLE employee ADD CONSTRAINT emp_dep_fk FOREIGN KEY (dept_id) REFERENCES department (id) ON UPDATE CASCADE;-- \u4fee\u6539\u5916\u952e\u8bbe\u7f6e\u7ea7\u8054\u66f4\u65b0\n\nALTER TABLE employee DROP FOREIGN KEY emp_dep_fk;-- \u5220\u9664\u5916\u952e\u7ea6\u675f\n\nALTER TABLE employee ADD CONSTRAINT emp_dep_fk FOREIGN KEY (dept_id) REFERENCES department (id) ON DELETE CASCADE ON update CASCADE;-- \u4fee\u6539\u5916\u952e\u8bbe\u7f6e\u7ea7\u8054\u66f4\u65b0\u4e0e\u5220\u9664\n\n<\/code><\/pre>\n
4\u3001DCL: \u6570\u636e\u63a7\u5236\u8bed\u53e5\uff0c\u6743\u9650\u63a7\u5236\uff0c\u7ba1\u7406\u7528\u6237\uff0c\u6388\u6743<\/h2>\n
4.1\u3001\u7528\u6237\u7ba1\u7406<\/h3>\n
# \u67e5\u8be2\uff0c\u7528\u6237\u4fe1\u606f\u4fdd\u5b58\u5728mysql\u6570\u636e\u5e93\u7684user\u8868\u4e2d\nSHOW TABLES;\nSELECT*FROM user;\n\n# \u521b\u5efa\u7528\u6237\nCREATE USER 'yusian' @'localhost' IDENTIFIED BY 'Root@123';\n\n# \u5220\u9664\u7528\u6237\nDROP USER 'yusian'@'localhost';\n\n# \u4fee\u6539\u7528\u6237\u5bc6\u7801\n-- \u65b9\u5f0f\u4e00\uff1a\u4fee\u6539\u8868\u5b57\u6bb5\nUPDATE USER SET authentication_string=PASSWORD ('Root@123') WHERE USER='yusian';\nFLUSH PRIVILEGES;-- \u5982\u679c\u662f\u4fee\u6539\u6570\u636e\u5e93\u5b57\u6bb5\u503c\u7684\u65b9\u5f0f\u4fee\u6539\uff0c\u5219\u9700\u8981\u624b\u52a8\u5237\u65b0\u7528\u6237\u6743\u9650\u4ee5\u4f7f\u5176\u751f\u6548\n\n-- \u65b9\u5f0f\u4e8c\uff1aset password\u547d\u4ee4\uff0c\u5f53\u524d\u7528\u6237\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528set password=password('xxx');\nSET PASSWORD FOR 'yusian' @'localhost'=PASSWORD ('Root@123'); -- \u7acb\u5373\u751f\u6548\uff0c\u4e0d\u9700\u8981flush privileges\n\n-- \u5982\u679c\u5fd8\u8bb0\u5bc6\u7801\u4e86\uff0c\u4f7f\u7528skip-grant-tables\u4e34\u65f6\u53d6\u6d88\u9274\u6743\uff0c\u7136\u540e\u8fdb\u5165mysql\u4fee\u6539\u5bc6\u7801\n# 1\u3001\u505c\u6b62mysql\u670d\u52a1\n# 2\u3001mysqld --user=root --skip-grant-tables\n# 3\u3001mysql\u76f4\u63a5\u8fdb\u5165\u6570\u636e\u5e93\u63a7\u5236\u53f0\uff0c\u4fee\u6539\u5bc6\u7801\n<\/code><\/pre>\n
4.2\u3001\u6743\u9650\u7ba1\u7406<\/h3>\n
SHOW GRANTS FOR 'root' @'localhost';-- \u67e5\u770b\u6743\u9650\n\n# \u6388\u6743\nGRANT ALL ON*.*TO 'xxx' @'xxx';\nGRANT SELECT ON db3.account TO 'yusian' @'localhost';\n# \u64a4\u9500\u6743\u9650\nREVOKE ALL ON*.*FROM 'xxx' @'xxx';\nREVOKE ALL ON db3.account FROM 'yusian' @'localhost';\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
1\u3001DDL: \u6570\u636e\u5b9a\u4e49\u8bed\u53e5\uff0c\u64cd\u4f5c\u5e93\u6216\u8868 ## \u5e93\u64cd\u4f5c SHOW DATABASES;– \u67e5\u770b\u6570\u636e\u5e93 CREATE DATABASE db;– \u521b\u5efa\u6570\u636e\u5e93 USE db;– \u4f7f\u7528\/\u5207\u6362\u6570\u636e\u5e93 SELECT DATABASE ();– \u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93 DROP DATABASE db;– \u5220\u9664\u6570\u636e\u5e93 ## \u8868\u64cd\u4f5c USE db1;– \u5207\u6362\u6570\u636e\u5e93 SHOW TABLES;– \u67e5\u770b\u6240\u6709\u8868 CREATE TABLE t_demo (– \u521b\u5efa\u6570\u636e\u5e93 id INT PRIMARY KEY auto_increment,– \u6307\u5b9a\u8be5\u5b57\u6bb5\u4e3a\u4e3b\u952e\uff0c\u81ea\u589e\u957f username VARCHAR (32),– \u5b57\u7b26\u957f\u5ea6\u4e3a32\u4e2a\u5b57\u8282 update_time TIMESTAMP– \u65f6\u95f4\u6233\u7c7b\u578b\uff0c\u4e3a\u7a7a\u5219\u81ea\u52a8\u586b\u5145\u4e3a\u5f53\u524d\u65f6\u95f4 ) CHARACTER SET utf8mb4;– \u6307\u5b9a\u5b57\u7b26\u96c6\u7684utf8mb4 CREATE TABLE […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[282],"tags":[22,283],"class_list":["post-1605","post","type-post","status-publish","format-standard","hentry","category-database","tag-mysql","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/posts\/1605","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/comments?post=1605"}],"version-history":[{"count":0,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/posts\/1605\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/media?parent=1605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/categories?post=1605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/tags?post=1605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}