時間:2024-02-28 13:28作者:下載吧人氣:19
使用插入數據命令:
>insert
需要注意的是,如果插入一文件(現在理解,nosql 類型的db數據不能說是記錄了,它是已文件作為單位,而傳統型的關系型數據庫,我們說是插入一條記錄),如果沒有帶人_id,那么會自動生成一個唯一的id,這個id好比關系型數據庫里的主鍵一樣。
如果是自己指定id,那么必須id是唯一的,這點關系型和nosql型都必須要求的;
數據字段的名字不能包含$ 和.
在敲了一陣發現,擦,我要是再shell里面去編寫復雜的插入語句,就shell的這種一行一句,不搞死我去啊。我想它肯定是支持向bat這種批處理或者其他,看它語法和js一模一樣,于是大膽猜測它使用的就是javascript,于是我就用notepad++來編輯這些插入命令,試著插入復雜的對象;
哦,另外說一句,如果這個bios數據不存在,那么要先使用
>use bios
生成一個數據庫,如果你不往這里插入一筆數據,mongoDB會自動刪除掉這個數據庫;
所以還要插入一筆讓mongodb維持這數據庫的任意數據
>db.bios.insert({a:'a'})
編寫了一個insert.js腳步,放在安裝目錄的js文件夾下。于是這樣輸入:
>mongolocalhost:27017/bios f:mongodbjsinsert.js
效果如圖
可以看到,這個js腳步成功執行;
要查詢這個文檔,輸入命令:
>db.bios.find({ name: { first: 'John', last: 'chen' } } );
有了js寫更多的語句,就方便多了。
Isert語句支持多個批量插入就像下面這樣:
Insert.js 語句:
db.bios.insert(
[
{
_id: 3,
name: { first: ‘Grace’, last: ‘Hopper’ },
title: ‘Rear Admiral’,
birth: new Date(‘Dec 09, 1906’),
death: new Date(‘Jan 01, 1992’),
contribs: [ ‘UNIVAC’, ‘compiler’, ‘FLOW-MATIC’, ‘COBOL’ ],
awards: [
{
award: ‘Computer Sciences Man of the Year’,
year: 1969,
by: ‘Data Processing Management Association’
},
{
award: ‘Distinguished Fellow’,
year: 1973,
by: ‘ British Computer Society’
},
{
award: ‘W. W. McDowell Award’,
year: 1976,
by: ‘IEEE Computer Society’
},
{
award: ‘National Medal of Technology’,
year: 1991,
by: ‘United States’
}
]
},
{
_id: 4,
name: { first: ‘Kristen’, last: ‘Nygaard’ },
birth: new Date(‘Aug 27, 1926’),
death: new Date(‘Aug 10, 2002’),
contribs: [ ‘OOP’, ‘Simula’ ],
awards: [
{
award: ‘Rosing Prize’,
year: 1999,
by: ‘Norwegian Data Association’
},
{
award: ‘Turing Award’,
year: 2001,
by: ‘ACM’
},
{
award: ‘IEEE John von Neumann Medal’,
year: 2001,
by: ‘IEEE’
}
]
},
{
_id: 5,
name: { first: ‘Ole-Johan’, last: ‘Dahl’ },
birth: new Date(‘Oct 12, 1931’),
death: new Date(‘Jun 29, 2002’),
contribs: [ ‘OOP’, ‘Simula’ ],
awards: [
{
award: ‘Rosing Prize’,
year: 1999,
by: ‘Norwegian Data Association’
},
{
award: ‘Turing Award’,
year: 2001,
by: ‘ACM’
},
{
award: ‘IEEE John von Neumann Medal’,
year: 2001,
by: ‘IEEE’
}
]
}
]
);
db.bios.insert(
{
name: { first: ‘John’, last: ‘McCarthy’ },
birth: new Date(‘Sep 04, 1927’),
death: new Date(‘Dec 24, 2011’),
contribs: [ ‘Lisp’, ‘Artificial Intelligence’, ‘ALGOL’ ],
awards: [
{
award: ‘Turing Award’,
year: 1971,
by: ‘ACM’
},
{
award: ‘Kyoto Prize’,
year: 1988,
by: ‘Inamori Foundation’
},
{
award: ‘National Medal of Science’,
year: 1990,
by: ‘National Science Foundation’
}
]
}
)
c = db.bios.find( { name: { first: ‘John’, last: ‘McCarthy’ } } );
while((c.hasNext())) printjson(c.next())
網友評論