Home Database Mysql Tutorial mongodb update 字符 操作

mongodb update 字符 操作

Jun 07, 2016 pm 04:37 PM
mongodb update under character operate use

下面常用的update操作,用mongodb2.6.3版本测试的,官方发布的稳定版本2.4,建议用稳定版。 一,upsert表示如果有数据就不插入,没数据就插入 1,命令行下 db.peoples.update( //查找name等于tank的用户... { name: "tank" },... {... "_id":1,... name: "An

下面常用的update操作,用mongodb2.6.3版本测试的,官方发布的稳定版本2.4,建议用稳定版。

一,upsert表示如果有数据就不插入,没数据就插入

1,命令行下

> db.peoples.update(        //查找name等于tank的用户
... { name: "tank" },
... {
... "_id":1,
... name: "Andy",
... rating: 10,
... score: 10
... },
... { upsert: true }      //如果没有就插入
... );
WriteResult({ "nMatched" : 0, "nUpserted" : 1, "_id" : 1 })
> db.peoples.find();
{ "_id" : 1, "name" : "Andy", "rating" : 10, "score" : 10 }
> db.peoples.update(
... { _id: 1 },
... {
... "_id":1,
... name: "Andy",
... rating: 10,
... score: 10
... },
... { upsert: true }
... );
WriteResult({ "nMatched" : 1, "nUpserted" : 0 })   //有匹配数据就不做插入操作
> db.peoples.find();
{ "_id" : 1, "name" : "Andy", "rating" : 10, "score" : 10 }
Copy after login

2,php upsert操作

$collection->update(
 array("name" => "zhang"),
 array("_id"=>2,"name"=>"tank","rating"=>10,"score"=>10),
 array("upsert" => true)
);
print_r($collection->findOne());
Copy after login

二,$set 替换值

1,命令行下操作

> db.peoples.find();
{ "_id" : 1, "name" : "Andy", "rating" : 10, "score" : 10 }
> db.peoples.update(
... { _id: 1 },
... {
... $set: { rating: 18 }
... }
... );
WriteResult({ "nMatched" : 1, "nUpserted" : 0 })
> db.peoples.find();
{ "_id" : 1, "name" : "Andy", "rating" : 18, "score" : 10 }
Copy after login

2,php $set操作

$where = array("_id"=>1);
$param = array('$set'=>array("score"=>"100")); //注意此处的set必须为 单引号
$collection->update($where,$param);
print_r($collection->findOne());
Copy after login

三,$inc如果没有对应对段就直接赋值,如果有在原来的值上加上该值

1,命令行下操作

> db.peoples.find();
{ "_id" : 1, "name" : "Andy", "rating" : 28, "score" : 10 }
> db.peoples.update(
... { _id: 1 },
... {
... $inc: { age: 30 }
... }
... );
WriteResult({ "nMatched" : 1, "nUpserted" : 0 })
> db.peoples.find();
{ "_id" : 1, "age" : 30, "name" : "Andy", "rating" : 28, "score" : 10 }    //第一次,加了一个字段
> db.peoples.update(
... { _id: 1 },
... {
... $inc: { age: 30 }
... }
... );
WriteResult({ "nMatched" : 1, "nUpserted" : 0 })
> db.peoples.find();
{ "_id" : 1, "age" : 60, "name" : "Andy", "rating" : 28, "score" : 10 }   //第二次,发现有这个字段就把值加上去了
Copy after login

2,php $inc操作

$where = array("_id"=>1);
$param = array('$inc'=>array("age"=>30));
$collection->update($where,$param);
print_r($collection->findOne());
Copy after login

四,$unset删除字段

1,命令行下操作

> db.peoples.find();
{ "_id" : 1, "age" : 120, "name" : "Andy", "rating" : 28, "score" : 10 }
> db.peoples.update(
... { _id: 1 },
... {
... $unset: { age: ""}    //删除age字段
... }
... );
WriteResult({ "nMatched" : 1, "nUpserted" : 0 })
> db.peoples.find();
{ "_id" : 1, "name" : "Andy", "rating" : 28, "score" : 10 }
>
Copy after login

2,php $unset操作

$where = array("_id"=>1);
$param = array('$unset'=>array("score"=>""));
$collection->update($where,$param);
print_r($collection->findOne());
Copy after login

五,$rename修改字段名称

1,命令行下操作

> db.peoples.find();
{ "_id" : 1, "name" : "Andy", "rating" : 28 }
> db.peoples.update(
... { _id: 1 },
... { $rename: { "name": "firstname" } }   //将name改成firstname
... );
WriteResult({ "nMatched" : 1, "nUpserted" : 0 })
> db.peoples.find();
{ "_id" : 1, "firstname" : "Andy", "rating" : 28 }
Copy after login

2,php $rename 操作

$where = array("_id"=>1);
$param = array('$rename'=>array("firstname"=>"name"));   //将firstname改成name
$collection->update($where,$param);
print_r($collection->findOne());
Copy after login

六,multi更新多条数据

1,命令行下操作

> db.peoples.find();
{ "_id" : 1, "name" : "Andy", "rating" : 28 }
{ "_id" : 2, "name" : "zhang", "rating" : 3, "score" : 5 }
{ "_id" : 3, "name" : "hao", "rating" : 30, "score" : 5 }
> db.peoples.update(
... { rating: { $gt: 15 } },
... { $inc: { score: 10 } },
... { multi: true }
... );
WriteResult({ "nMatched" : 2, "nUpserted" : 0 })
> db.peoples.find();
{ "_id" : 1, "name" : "Andy", "rating" : 28, "score" : 10 }      //这条数据更新了
{ "_id" : 2, "name" : "zhang", "rating" : 3, "score" : 5 }
{ "_id" : 3, "name" : "hao", "rating" : 30, "score" : 15 }     //这条数据更新了
Copy after login

2,php multi操作

$where = array("rating"=>array('$gt'=>10));
$param = array('$set'=>array("name"=>"tank1","rating"=>50));
$ismore = array("multiple" => true);
$collection->update($where,$param,$ismore);
Copy after login

版本不一样,功能多少会不一样,例如,我用的版本是2.6.3,$min和$max就用不了,会报"errmsg" : "Invalid modifier specified $min",希望mongodb出一个稳定高版本。

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Which version is generally used for mongodb? Which version is generally used for mongodb? Apr 07, 2024 pm 05:48 PM

It is recommended to use the latest version of MongoDB (currently 5.0) as it provides the latest features and improvements. When selecting a version, you need to consider functional requirements, compatibility, stability, and community support. For example, the latest version has features such as transactions and aggregation pipeline optimization. Make sure the version is compatible with the application. For production environments, choose the long-term support version. The latest version has more active community support.

The difference between nodejs and vuejs The difference between nodejs and vuejs Apr 21, 2024 am 04:17 AM

Node.js is a server-side JavaScript runtime, while Vue.js is a client-side JavaScript framework for creating interactive user interfaces. Node.js is used for server-side development, such as back-end service API development and data processing, while Vue.js is used for client-side development, such as single-page applications and responsive user interfaces.

Where is the database created by mongodb? Where is the database created by mongodb? Apr 07, 2024 pm 05:39 PM

The data of the MongoDB database is stored in the specified data directory, which can be located in the local file system, network file system or cloud storage. The specific location is as follows: Local file system: The default path is Linux/macOS:/data/db, Windows: C:\data\db. Network file system: The path depends on the file system. Cloud Storage: The path is determined by the cloud storage provider.

What are the advantages of mongodb database What are the advantages of mongodb database Apr 07, 2024 pm 05:21 PM

The MongoDB database is known for its flexibility, scalability, and high performance. Its advantages include: a document data model that allows data to be stored in a flexible and unstructured way. Horizontal scalability to multiple servers via sharding. Query flexibility, supporting complex queries and aggregation operations. Data replication and fault tolerance ensure data redundancy and high availability. JSON support for easy integration with front-end applications. High performance for fast response even when processing large amounts of data. Open source, customizable and free to use.

What does mongodb mean? What does mongodb mean? Apr 07, 2024 pm 05:57 PM

MongoDB is a document-oriented, distributed database system used to store and manage large amounts of structured and unstructured data. Its core concepts include document storage and distribution, and its main features include dynamic schema, indexing, aggregation, map-reduce and replication. It is widely used in content management systems, e-commerce platforms, social media websites, IoT applications, and mobile application development.

KDE Plasma 6.1 brings many enhancements to the popular Linux desktop KDE Plasma 6.1 brings many enhancements to the popular Linux desktop Jun 23, 2024 am 07:54 AM

After several pre-releases, the KDE Plasma development team unveiled version 6.0 of its desktop environment for Linux and BSD systems on 28 February, using the Qt6 framework for the first time. KDE Plasma 6.1 now comes with a number of new features t

Where are the mongodb database files? Where are the mongodb database files? Apr 07, 2024 pm 05:42 PM

The MongoDB database file is located in the MongoDB data directory, which is /data/db by default, which contains .bson (document data), ns (collection information), journal (write operation records), wiredTiger (data when using the WiredTiger storage engine ) and config (database configuration information) and other files.

How to open mongodb How to open mongodb Apr 07, 2024 pm 06:15 PM

On Linux/macOS: Create the data directory and start the "mongod" service. On Windows: Create the data directory and start the MongoDB service from Service Manager. In Docker: Run the "docker run" command. On other platforms: Please consult the MongoDB documentation. Verification method: Run the "mongo" command to connect and view the server version.

See all articles