mongodb update 字符 操作
下面常用的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 }
2,php upsert操作
$collection->update( array("name" => "zhang"), array("_id"=>2,"name"=>"tank","rating"=>10,"score"=>10), array("upsert" => true) ); print_r($collection->findOne());
二,$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 }
2,php $set操作
$where = array("_id"=>1); $param = array('$set'=>array("score"=>"100")); //注意此处的set必须为 单引号 $collection->update($where,$param); print_r($collection->findOne());
三,$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 } //第二次,发现有这个字段就把值加上去了
2,php $inc操作
$where = array("_id"=>1); $param = array('$inc'=>array("age"=>30)); $collection->update($where,$param); print_r($collection->findOne());
四,$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 } >
2,php $unset操作
$where = array("_id"=>1); $param = array('$unset'=>array("score"=>"")); $collection->update($where,$param); print_r($collection->findOne());
五,$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 }
2,php $rename 操作
$where = array("_id"=>1); $param = array('$rename'=>array("firstname"=>"name")); //将firstname改成name $collection->update($where,$param); print_r($collection->findOne());
六,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 } //这条数据更新了
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);
版本不一样,功能多少会不一样,例如,我用的版本是2.6.3,$min和$max就用不了,会报"errmsg" : "Invalid modifier specified $min",希望mongodb出一个稳定高版本。
原文地址:mongodb update 字符 操作, 感谢原作者分享。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

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.

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.

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.

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.

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.

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

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.

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.
