In this post, We will learn How to delete the existing mongo database. MongoDB shell command `db.dropDatabase()` is used to drop an existing database and their associated data files. It will block other operations While dropping a database. The basic syntax for deleting a database is Syntax: db.dropDatabase() This command will drop the currently selected […]
This post will help us to learn How to add document in the MongoDB collection. MongoDB has `insert()` and `save()` method to add a document into collection. Syntax: db.COLLECTION_NAME.insert(document) Insert Single record: Example: > use learnmongodb switched to db learnmongodb > db.books.insert({ ‘title’:’MongoDB’, ‘description’:’Learn MongoDB with NoSQL’, ‘version’:’4.x’ }) WriteResult({ “nInserted” : 1 }) [OR] […]
This tutorial will help you to get a clear understanding to use the query operations using the db.collection.find() function. Sample Collection Query Documents Query on Embedded/Nested Documents Query an Array Query an Array of Embedded Documents Sample Collection I am going to use the below `books` collection for all the sample query. db.books.insertMany([ { “name” […]
Now we will learn how to create database. Database names are case sensitive. so we must have to refer our database in lower case “databasename” not “DataBaseName” in linux. This case sensitive concept is also true for tables. Create Database Use Database Drop Database Create Database When the users create a database, it is stored […]
User Table Userid Username 1 Name1 2 Name2 3 Name3 Subscription Table SubId SubName 1 Subname1 2 Subname2 User_Subscription Table Userid SubId 1 1 1 2 2 2 3 1 Many To Many Search Format1 How Many users Subscripted in 1 or 2 SELECT Userid,SubId, count(*) as countt FROM User_Subscription e where Subscripted in (2,1) […]
This tutorial will help you to understand about “MYSQL Date and Time Data Types”. Storage Required For Date And Time Types YEAR Type TIME Type DATE, DATETIME AND TIMESTAMP Type Storage Requirements for Date and Time Types TIME, DATETIME, TIMESTAMP storage details showed in following table. Data Type Storage Required YEAR 1 byte DATE 3 […]
What is MySQL MySql RDBMS MySql Open Source MySql Limits MySql Connectivity Languages MySql License MySql Features And Versions What is MySQL? A database is a structured collection of data. It may be text, number, images etc. As a developer, we need to manage the database to store , access and modify. Mysql is the […]
This tutorial will help you to understand about “MYSQL Numeric Data Types”. Storage Required For Numeic Types Integer Types Storage Required For Numeic Types Data Type Storage Required TINY INT 1 byte SMALL INT 2 bytes MEDIUM INT 3 bytes INT INTEGER 4 bytes BIGINT 8 bytes FLOAT(p) 4 bytes DOUBLE[PRECISION], REAL 8 bytes DECIMAL(M,D), […]
MYSQL Connection To Server MYSQL Disconnect From Server MYSQL Connection To Server Host, user and password parameters are needed to connect the mysql server. We have to connect server like this shell>mysql -h host -u user -p Enter Password: ******* host – Where MYSQL server is running user – username of MYSQL server password – […]
This tutorial will help you to understand about “MYSQL String Types”. It contains the storage required for string types, CHAR type, VARCHAR type, TEXT types, BLOB types, ENUM type and SET TYPE. Storage Required For String Types CHAR ,VARCHAR TYPE TEXT TYPES BLOB TYPES ENUM TYPE SET TYPE Storage Requirements for String Types In the […]