Mongovue the use of additions and deletions to check operation instructions

Mongovue the use of additions and deletions to check operation instructions

First, query

1. Accurate Query

1) Right click on the collection name and then left click Find

Or simply click Find on the toolbar

2) query interface, including four regions

{"Find}", the query conditional format {"Sendid": "000101"} represents a record of query sendid=000101, (note: MongoDB is case-sensitive, written as {"Sendid": "000101"} will not be queried) when the query condition contains and, The format is: {"Sendid": "000101", "OPERPARAM5": "Vfre"} when the query condition contains or, the format is

{$or: [{"Sendid": "000101"},{"Sendid": "1234567890"}]}

{fields} area, which represents the field value of the query and does not fill in all fields by default. The fields are formatted similar to the find area, such as: {"id": "", "Sendid": "", "AppId": "}

{sort} area, {"id": 1} is sorted by id ascending, {"id":-1} is sorted by ID descending

Skip and limit are used together, which is equivalent to querying the limit statement in MySQL

(Note: The value of skip and limit cannot be empty, otherwise it will be an error)

2. Fuzzy query

When the query condition contains like, the format is: {"OPERPARAM5": New RegExp (". *set.*")}

Here we use a simple regular expression:. * denotes any number of characters, equal to% in like.

If the query operParam5 like '%set% ', write {"OPERPARAM5": New RegExp (". *set.*")} if the query operParam5 like '%set ', write {"OPERPARAM5": New RegExp (". *set")}

If the query operParam5 like ' set% ', write {"OPERPARAM5": New RegExp ("Set.*")}

Second, new

1) Right click on the collection name, then left click Insert Document ...

2) in the Popup input box, fill in the Bson format data to insert the record

3. Tap Insert to add success

Third, the editor

1) Click the Update button on the menu bar

2) Enter the query criteria on the left, enter the field name and field values to update on the right

The following example implements the Sendid field value for the record id= aaaa84e71ffb470ca8c80d309c4bc835, modified to 000001

3) After that, click UpdateAll to update all records.

Iv. deletion

3) Click the Remove button on the menu bar

4) Enter the query criteria for the record you want to delete.

The following example deletes id=aaa684e71ffb470ca8c80d309c4bc835 records

3) Click the Remove button to pop up the confirmation prompt and click Remove.

Ext.: http://blog.csdn.net/tfy1332/article/details/46683183

Mongovue the use of additions and deletions to check operation instructions