> Use mongo_test//CREATE DatabaseSwitched to DB Mongo_test> db.createcollection ("Test")//CREATE TABLE is the collection{"OK": 1}> DB.Db.adduser (Db.group (Db.admincommand (Db.groupcmd (Db.auth (Db.groupeval (Db.changeuserpassword (Db.hasownproperty
1. Turn on MongoDB service 1 sudo service MongoDB start2. Enter the MongoDB command line interface to exit at the command line by knocking exit 1 MONGO3.find () Basic query usage: DB. Collection_name.find ();--(the concept of a set collections in
Organize fromHttps://www.shiyanlou.com/courses/running/57Start$ sudo service mongodb startEnter the MongoDB command-line interface and exit at the command line by knocking exit$ mongoThe ture of the Boolean type in the experiment is replaced with 1,
1. Installing the MongoDB DatabaseMongoDB Official website: https://www.mongodb.orgAfter installation, the following steps are played:The first step: Planning your installation directory and database file storage path, I intend to place MONGO
I used to use MongoDB, in the evening check the need for the command, about how MongoDB how to use, I do not knowOfficial website: http://www.mongodb.org/MongoDB installation, master-slave configurationOne MongoDB installationClick ( here) to
MongoDB is a product between a relational database and a non-relational database, and is the most versatile and most like relational database in a non-relational database. The data structure he supports is very loose and is a JSON-like Bjson format,
Environment Description: MongoDB 2.4.10-2.6.61. Start with daemon configuration fileMongod-f/etc/mongodb.conf2. Join the Boot startup itemecho "Mongod-f/etc/mongodb.conf;" >>/etc/rc.localIf the boot entry is not valid, please refer to the link: http:
1. Download the software:wget https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-rhel62-3.0.3.tgz2. Unzip the installation:TAR-ZXVF mongodb-linux-x86_64-rhel62-3.0.3.tgzMV mongodb-linux-x86_64-rhel62-3.0.3/usr/local/cd/usr/local/Ln-s
For the MongoDB package is still continuing, for the continuous pursuit of simple programming continues, for like the Code of the feeling, still continue ...When your MONGO data table has sub-objects, especially the list objects, the use of the
Differences between indexes in MyISAM and InnoDBTwo small tables, item and category:
CREATE TABLE `item` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `category_id` mediumint(8) unsigned NOT NULL, PRIMARY
Mongodb Study Notes 05-user managementEnable authentication
Mongod does not have the permission to start by default. You need to specify-auth to start, or set security. authorization to "enabled" in the configuration file"Create user
Db. createUser (
The database updates multiple records with different values and updates multiple fields at the same time
Requirement
The following two tables are student (student table) and score (test student table)
Statistics: total score and average score of
Data cleansing Note: Generation of primary key class ID Fields
Background]
After data is extracted from the source end and inserted to the target end, a primary key ID field needs to be created.
[Solution]
Method 1: Use the sys_guid () function
Mybatis delayed Loading
If you have such a requirement, You need to query all the orders and obtain detailed information about the orders.
If all the required data is requested at one time, the overhead on the server and database will be high.
About OGG & quot; LoadingdatafromfiletoReplicat & quot; key parameters for synchronizing partial records containing the lob field table
Key parameters for synchronizing partial records containing the lob field table in OGG "Loading data from file to
MongoDB query commands
1. query all records
Copy the Code as follows:
db.userInfo.find();
Equivalent:Select * from userInfo;By default, 20 records are displayed on each page. If no record is displayed, you can use the it iteration command to query
Storage and file managementStorage and file management
Purpose
(1) master the creation and management of tablespaces.
(2) master the management operations such as viewing and modifying the tablespace under the OEM.
(3) master the creation,
Thoughts on data operation report system
Purpose:
Data indicators are the pulse of the product. Managers can understand the Product Operation overview by feeling the pulse changes.
Fragment
Tracking:
The ultimate goal of all tracking points is
/* + SYS_DL_CURSOR */This hint
Run the/* + SYS_DL_CURSOR */hint.
Today in a db SQL statement, encountered this/* + SYS_DL_CURSOR */hint, after baidu, In the post of Huang Wei http://www.hellodba.com/reader.php? ID = 201It is described as follows:
Import Excel table data to Sqlite database tableImport the Excel table data to Sqlite database table 1. First, prepare the Excel file, open the Excel file, and save it as a *. csv file. 2. You need to create fields for Excel Data in Sqlite according
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service