mongodb安装笔记【服务没有及时响应或控制请求】-Mysql Tutorial-php.cn

Table of Contents

Create and Alter

Insert

Select

Update Records

Delete Records

Home

Database

Mysql Tutorial

mongodb安装笔记【服务没有及时响应或控制请求】

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:28 PM

mongodb response Install control Serve notes

mongodb安装笔记 --下面大部分都是参考网上资料，仅仅作为笔记使用参考链接 Mongodb官网安装 Mongodb官网对比相关文档我的mongodb安装在[d:\Java\mongodb] 所以需要根目录手动创建文件夹【e:\data\db】 mongodb使用服务方式安装 D:\Java\mongodb\bin\mong

mongodb安装笔记

--下面大部分都是参考网上资料，仅仅作为笔记使用

参考链接

Mongodb官网安装

Mongodb官网对比

Create and Alter

The following table presents the various SQL statements related totable-level actions and the corresponding MongoDB statements.

SQL Schema Statements MongoDB Schema Statements Reference

CREATE TABLE users (
    id MEDIUMINT NOT NULL
        AUTO_INCREMENT,
    user_id Varchar(30),
    age Number,
    status char(1),
    PRIMARY KEY (id)
)

Copy after login

Implicitly created on first insert() operation. The primary key_idis automatically added if_id field is not specified.

db.users.insert( {
    user_id: "abc123",
    age: 55,
    status: "A"
 } )

Copy after login

However, you can also explicitly create a collection:

1	`db.createCollection("users")`

Copy after login

Seeinsert() anddb.createCollection()for more information.

1 2	`ALTER TABLE users` `ADD join_date DATETIME`

Copy after login

Collections do not describe or enforce the structure of itsdocuments; i.e. there is no structural alteration at thecollection level.

However, at the document level, update() operations can add fields to existingdocuments using the$set operator.

db.users.update(
    { },
    { $set: { join_date: new Date() } },
    { multi: true }
)

Copy after login

See the Data Modeling Concepts, update(), and$set for moreinformation on changing the structure of documents in acollection.

1 2	`ALTER TABLE users` `DROP COLUMN join_date`

Copy after login

Collections do not describe or enforce the structure of itsdocuments; i.e. there is no structural alteration at the collectionlevel.

However, at the document level, update() operations can remove fields fromdocuments using the$unset operator.

db.users.update(
    { },
    { $unset: { join_date: "" } },
    { multi: true }
)

Copy after login

See Data Modeling Concepts, update(), and$unset for more information on changing the structure ofdocuments in a collection.

1 2	`CREATE INDEX idx_user_id_asc` `ON users(user_id)`

Copy after login

1	`db.users.ensureIndex( { user_id: 1 } )`

Copy after login

See ensureIndex()andindexes for more information.

CREATE INDEX
       idx_user_id_asc_age_desc
ON users(user_id, age DESC)

Copy after login

1	`db.users.ensureIndex( { user_id: 1, age: -1 } )`

Copy after login

See ensureIndex()andindexes for more information.

1	`DROP TABLE users`

Copy after login

1	`db.users.drop()`

Copy after login

See drop() formore information.

Insert

The following table presents the various SQL statements related toinserting records into tables and the corresponding MongoDB statements.

SQL INSERT Statements MongoDB insert() Statements Reference

INSERT INTO users(user_id,
                  age,
                  status)
VALUES ("bcd001",
        45,
        "A")

Copy after login

db.users.insert( {
       user_id: "bcd001",
       age: 45,
       status: "A"
} )

Copy after login

See insert() for more information.

Select

The following table presents the various SQL statements related toreading records from tables and the corresponding MongoDB statements.

SQL SELECT Statements MongoDB find() Statements Reference

1 2	`SELECT *` `FROM users`

Copy after login

1	`db.users.find()`

Copy after login