当前位置: 代码迷 >> 其他数据库 >> mongo SyntaxError解决办法
  详细解决方案

mongo SyntaxError解决办法

热度:3402   发布时间:2013-02-26 00:00:00.0
mongo SyntaxError
> SELECT * FROM things WHERE name="mongo";
Tue Dec 20 17:45:42 SyntaxError: missing ; before statement (shell):1
> db.things.find();
{ "_id" : ObjectId("4ef0590704ccf7a2074986f4"), "x" : 4, "j" : 1 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986f5"), "x" : 4, "j" : 2 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986f6"), "x" : 4, "j" : 3 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986f7"), "x" : 4, "j" : 4 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986f8"), "x" : 4, "j" : 5 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986f9"), "x" : 4, "j" : 6 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986fa"), "x" : 4, "j" : 7 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986fb"), "x" : 4, "j" : 8 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986fc"), "x" : 4, "j" : 9 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986fd"), "x" : 4, "j" : 10 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986fe"), "x" : 4, "j" : 11 }
{ "_id" : ObjectId("4ef0590704ccf7a2074986ff"), "x" : 4, "j" : 12 }
{ "_id" : ObjectId("4ef0590704ccf7a207498700"), "x" : 4, "j" : 13 }
{ "_id" : ObjectId("4ef0590704ccf7a207498701"), "x" : 4, "j" : 14 }
{ "_id" : ObjectId("4ef0590704ccf7a207498702"), "x" : 4, "j" : 15 }
{ "_id" : ObjectId("4ef0590704ccf7a207498703"), "x" : 4, "j" : 16 }
{ "_id" : ObjectId("4ef0590704ccf7a207498704"), "x" : 4, "j" : 17 }
{ "_id" : ObjectId("4ef0590704ccf7a207498705"), "x" : 4, "j" : 18 }
{ "_id" : ObjectId("4ef0590704ccf7a207498706"), "x" : 4, "j" : 19 }
{ "_id" : ObjectId("4ef0590704ccf7a207498707"), "x" : 4, "j" : 20 }
has more
> it
{ "_id" : ObjectId("4ef0592004ccf7a207498708"), "name" : "mongo" }
{ "_id" : ObjectId("4ef0592604ccf7a207498709"), "x" : 3 }
> SELECT * FROM things WHERE name="mongo";
Tue Dec 20 17:52:09 SyntaxError: missing ; before statement (shell):1
>

为什么呢?

------解决方案--------------------------------------------------------
select语句不能再mongodb里执行
------解决方案--------------------------------------------------------
http://www.mongodb.org/display/DOCS/Querying
  相关解决方案