Skip to main content

Database Study Note: Four Basic MongoDB Commands You Should Know


MongoDB is one of the most popular database with Node.js and Express.js. It is a NoSQL database.

From Google Image
Firstly, we need to install MongoDB in our server. The course TA created a good installation tutorial video on YouTube.

Since the MongoDB has updated its system. In the installation, we need to set up the Ubuntu 16.04 (Xenial) code instead of 14.04 version which is shown on the video.

 Once we finish the installation, we need to call "./mongod" and run the code, then open a new terminal window, and call "mongo", then you are ready to use Mongo shell, which is like JavaScript console. 

We can type "help" to learn the main MongoDB commands and their explanation. 

After I learned this lecture, I summarized four basic MongoDB commands to do with your database: insert, find, update and remove.

Insert

I want to create a student databases which include student name and GPA score. I can use insert command to create the new data: db.students.insert({name: "Mary", GPA: "3.5"}).


In the code, "db" is the database we are on. "Students" is the collection, and "insert" is the command that will insert data into this students collection in the database.

I insert in an object with the student name "Mary" and GPA "3.5". If  I want to see the collection name, I can simple type "show collections". It gives me the "Students".



Find

To prove that the students collection is created, I use "find" to view the data: db.students.find().


Then, you can see the data in students collection with unique Mongo ID.

I insert a new student data, and then use the find command to view all the data.


If I only want to find the student with name equal to "Mary", I can type an object inside the find command: db.students.find({name: "Mary"}). It will give me all the data related to Mary.


Update

 If I want to update an existing student data by change the name "Mike" to "Tom", I could use update command: db.students.update({name: "Mike"}, {$set {name: "Tom"}})


Update takes two different things: the first one is something we select by. In this case, I select the student name "Mike". The second thing is how we want to update. I updated the name to "Tom".

Then, I call find command to see the new data. I can see the new name "Tom" has updated successfully.

Remove

If I want to remove the data, I can use remove command: db.students.remove({name: "Mary"}). Inside the remove, I can put the student name or GPA or ID to remove the data.


Remove will remove everything matches whatever you provide by default.






Labels:

Comments

Post a Comment

Popular posts from this blog

Intermediate Express.js: How To Add Styles & Partials in EJS File?

So far, we only have simple HTML tags and ejs tags in each ejs file. Every template page has no style at all. And the basic HTML header and footer are also missing. Today, I learned how to add styles and partials in ejs file. Link Style Step One: Touch a Separate CSS file I create a new directory "Style" under the "EJSDemo" directory, then I add a new CSS file "app.css" inside "Style" folder. Step Two: Add app.use(express.static()) in the app.js I add app.use(express.static("style")) in the "app.js". This will tell Express.js to serve the content of "Style" directory. Step Three: Write styles in CSS file I simple give body an orange background color and set text color to be grey. Step Four: Link to CSS file in the EJS file I just add <link> tag to link the "app.css" file on the top of the h1 tag in each ejs template. As the result, when I run the app and...
Post a Comment
Read more

My Story: A Mommy Start To Learn Code From Zero

From Google Image I am not a programmer, and I thought I would never become one. Everytime I see someone is coding, I think he or she must be very talent.  For me, coding is a very difficult subject to learn. Not only the language has so many rules, but also the logical reasoning behind the language is complex.  In my graduated school, I knew many friends who didn't have any coding background, but they are doing programmer or developer jobs now. Some of them went to school to study coding, and some of them  learned to code by themselves. Their stories are so impressive.  I wasn't ready to learn code until I finished my first Chinese book "留学，我的青春呀!" recently. I always want to be a writer and write my own book. I started writing blog three years ago, and I updated my post two to three times every week. As I enjoyed writing , I started to get some followers, likes, and good comments on my blog. Then, I decided to plan my first book. My First...
Post a Comment
Read more

Three Most Common HTML Form Elements You Should Know

When I visited the Facebook page at the first time, it required me to sign up. Therefore, I completed the sign up form to create my new account. The form is very simple to fill in because it only asks for very common information such as full name, phone number, new password, birthday, and gender. It only took me one or two minutes to finish the form. Not only Social media sites require us to sign up first before we post anything, but many business or eCommerce sites also ask us to create new account before we take any action. For example, when I go to the Origins skin care site, it will pop up a email sign up form window. To encourage new customers to sign up, it gives a 15% off for the first order. It is definitely an attractive call-to-action message. Anyway, if your website requires users to sign up, you need to know how to create a HTML form. Yesterday, I just learned how to build a simple HTML form from Udemy course. And it is not that hard. All you need to kno...
Post a Comment
Read more