<\/span><\/h3>\n\n\n\n\u6ce8\u610f2\u884c\u6570\u636e\uff0cname\u662f\u548c\u7b2c1\u884c\u6570\u636e\u76f8\uff0c\u4f46\u591a\u4e86birth\u6570\u636e\u3002<\/p>\n\n\n\n
> db.emp.employees.insert({id:1,name:\"First\"})\r\n{\r\n \"InsertedNum\": 1,\r\n \"DuplicatedNum\": 0\r\n}\r\nTakes 0.003210s.\r\n> db.emp.employees.insert({id:2,name:\"First\",birth:\"1990-12-13\"})\r\n{\r\n \"InsertedNum\": 1,\r\n \"DuplicatedNum\": 0\r\n}\r\nTakes 0.001932s.\r\n<\/code><\/pre>\n\n\n\n<\/span>\u901a\u8fc7execUpdate\u7684SQL\u683c\u5f0f<\/span><\/h3>\n\n\n\ninsert into () values ()<\/p>\n\n\n\n
> db.execUpdate(\"insert into emp.employees (id,name) values(3,'second')\");\r\n{\r\n \"InsertedNum\": 1,\r\n \"DuplicatedNum\": 0\r\n}\r\nTakes 0.019914s.\r\n> db.exec(\"select * from emp.employees where id='3'\");\r\nReturn 0 row(s).\r\nTakes 0.001557s.\r\n> db.exec(\"select * from emp.employees where id=3\");\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffee5c77606f131940aa9e3\"\r\n },\r\n \"id\": 3,\r\n \"name\": \"second\"\r\n}\r\nReturn 1 row(s).\r\nTakes 0.001759s.\r\n>\r\n<\/code><\/pre>\n\n\n\n<\/span>\u67e5\u8be2<\/span><\/h2>\n\n\n\n<\/span>\u5168\u8868\u67e5\u8be2<\/span><\/h3>\n\n\n\n> db.exec('select * from emp.employees');\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffef97795d25e56d34d79d7\"\r\n },\r\n \"id\": 1,\r\n \"name\": \"First\"\r\n}\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffef9e295d25e56d34d79d8\"\r\n },\r\n \"id\": 2,\r\n \"name\": \"First\",\r\n \"birth\": \"1990-12-13\"\r\n}\r\nReturn 2 row(s).\r\nTakes 0.003467s.\r\n<\/code><\/pre>\n\n\n\n<\/span>\u5e26\u6761\u4ef6\u67e5\u8be2<\/span><\/h3>\n\n\n\n\u6ce8\u610f\u6761\u4ef6\u662f\u6709\u7c7b\u578b\u7684\uff0c\u6bd4\u5982=1\u662f\u6570\u5b57\uff0c=\u20191\u2018\u662f\u5b57\u7b26\u4e32\uff0c\u7ed3\u679c\u4e0d\u4e00\u5b9a\u76f8\u7b49\u3002<\/p>\n\n\n\n
> db.exec('select * from emp.employees where id=1');\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffef97795d25e56d34d79d7\"\r\n },\r\n \"id\": 1,\r\n \"name\": \"First\"\r\n}\r\nReturn 1 row(s).\r\nTakes 0.002669s.\r\n> db.exec('select * from emp.employees where name=\"First\"');\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffef97795d25e56d34d79d7\"\r\n },\r\n \"id\": 1,\r\n \"name\": \"First\"\r\n}\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffef9e295d25e56d34d79d8\"\r\n },\r\n \"id\": 2,\r\n \"name\": \"First\",\r\n \"birth\": \"1990-12-13\"\r\n}\r\nReturn 2 row(s).\r\nTakes 0.002355s.\r\n>\r\n<\/code><\/pre>\n\n\n\n<\/span>\u67e5\u8be2\u552f\u4e00\u7684id<\/span><\/h3>\n\n\n\n> db.emp.employees.find({id:1})\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffef97795d25e56d34d79d7\"\r\n },\r\n \"id\": 1,\r\n \"name\": \"First\"\r\n}\r\nReturn 1 row(s).\r\nTakes 0.001672s.<\/code><\/pre>\n\n\n\n<\/span>\u67e5\u8be2\u6709\u91cd\u590d\u7684Name<\/span><\/h3>\n\n\n\n> db.emp.employees.find({name:\"First\"})\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffef97795d25e56d34d79d7\"\r\n },\r\n \"id\": 1,\r\n \"name\": \"First\"\r\n}\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffef9e295d25e56d34d79d8\"\r\n },\r\n \"id\": 2,\r\n \"name\": \"First\",\r\n \"birth\": \"1990-12-13\"\r\n}\r\nReturn 2 row(s).\r\nTakes 0.001782s.\r\n<\/code><\/pre>\n\n\n\n<\/span>\u66f4\u65b0<\/span><\/h2>\n\n\n\n\u66f4\u65b0\u64cd\u4f5c\u672c\u8eab\uff0c\u662f\u53ef\u4ee5\u589e\u52a0\u989d\u5916\u5c5e\u6027\u7684\uff0c\u7b49\u540c\u4e8e\u589e\u52a0\u4e86\u5b57\u6bb5\u3002<\/p>\n\n\n\n
\u5982\u4e0bupdate\u65f6\u7ed9id=3\u7684\u8bb0\u5f55\u589e\u52a0\u4e86birth\u5b57\u6bb5\uff0c\u5728\u524d\u9762insert into\u65f6\u662f\u6ca1\u6709\u7684\u3002<\/p>\n\n\n\n
> db.execUpdate(\"update emp.employees set birth='2020-12-13' where id=3\");\r\n{\r\n \"UpdatedNum\": 1,\r\n \"ModifiedNum\": 1,\r\n \"InsertedNum\": 0\r\n}\r\nTakes 0.002411s.\r\n> db.exec(\"select * from emp.employees where id=3\");\r\n{\r\n \"_id\": {\r\n \"$oid\": \"5ffee5c77606f131940aa9e3\"\r\n },\r\n \"birth\": \"2020-12-13\",\r\n \"id\": 3,\r\n \"name\": \"second\"\r\n}\r\nReturn 1 row(s).\r\nTakes 0.002100s.\r\n<\/code><\/pre>\n\n\n\n<\/span>\u5220\u9664<\/span><\/h2>\n\n\n\n\u6807\u51c6\u7684delete\u8bed\u6cd5\uff0c\u518d\u6b21\u67e5\u8be2\u5df2\u7ecf\u6ca1\u6709\u8bb0\u5f55\u3002<\/p>\n\n\n\n
> db.execUpdate(\"delete from emp.employees where id=3\");\r\n{\r\n \"DeletedNum\": 1\r\n}\r\nTakes 0.002337s.\r\n> db.exec(\"select * from emp.employees where id=3\");\r\nReturn 0 row(s).\r\nTakes 0.001677s.\r\n<\/code><\/pre>\n\n\n\n<\/span>Summary<\/span><\/h2>\n\n\n\n\u901a\u8fc7SQL\u7c7b\u578b\u7684\u64cd\u4f5c\uff0c\u8fdb\u884c\u6570\u636e\u7684\u589e\u5220\u6539\u67e5\u3002\u5176\u4e2dexec\u7528\u4e8e\u67e5\u8be2\uff0cexecUpdate\u7528\u4e8e\u589e\u52a0\uff0c\u66f4\u65b0\u548c\u5220\u9664\u3002\u8bed\u6cd5\u4e0e\u6807\u51c6SQL\u4e00\u81f4\u3002<\/p>","protected":false},"excerpt":{"rendered":"
\u672c\u6587\u4ecb\u7ecd\uff0c\u5728\u5de8\u6749SequoiaDB 5\u4e0a\u505a\u6700\u7b80\u5355\u7684\u589e\u5220\u6539\u67e5\u64cd\u4f5c\u7684\u4f8b\u5b50\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[79],"tags":[],"class_list":["post-3497","post","type-post","status-publish","format-standard","hentry","category-79"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=3497"}],"version-history":[{"count":10,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3497\/revisions"}],"predecessor-version":[{"id":3507,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/3497\/revisions\/3507"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=3497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=3497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=3497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}