Tech Library For Developers
In this tutorial, we will learn How to delete/Add a column in an existing table in MySQL, as adding and deleting are very important for a database. These all are done by DDL Data Defination Language as we are dealing with the manipulation of the Structure of the table. The update is the query that … Read more
In this Tutorial, we will learn What is MongoDB, As it is a database management system that deals which documents, Collections, and fields to store the data in a non-structural way where the structure is not a priority. Whichid developed by MongoDB inc. MongoDB MongoDB was founded by three friends Dwight Merriman, Eliot Horowitz, and … Read more
In this tutorial, we will learn to work with dates and times in MongoDB where we can perform a number of operations on data and time like sorting, querying dates, and aggregating dates that we are going to implement here one by one. Dates There are different ways and features that we may use on … Read more
In this tutorial, we will learn How to reset AUTO INCREMENT in MySQL where we can set the Auto_Increment =1 which means turning on the auto increment So that the values will be incremented by their own when we add a new row in the table to understand it follows the explaining given below. AUTO … Read more
In this tutorial, we will learn how to execute an SQL query to Select Only Rows With Max Value On A Column that we can do with the help of the max function to see how we can do so following the code given below. SQL Query to Select Rows With Max Value Of … Read more
Here we will learn What’s The Difference Between INNER JOIN, LEFT JOIN, RIGHT JOIN, And FULL JOIN? where joins are used for getting the data filtered and the selected data need to display with some conditions we will learn different conditions which are applied for each type of join present there. It is a way … Read more
In this tutorial, we will learn How To list All Databases In The Mongo Shell we can list all the databases in MongoDB in three ways one by the Show database command, Second could be the admin command with the simple show, and the admin command with detailed information of the database. Ways … Read more
Here we will learn How To Remove A Field Completely From A MongoDB Document where we can use the unset operator in the update function could remove a field completely from the document do so follow the example and code below and implementing it in your program. Remove The Selected Field From A MongoDB Document … Read more
Here we will learn How to Delete Everything In A MongoDB Database where we can delete documents in two ways multiple and drop the whole database where in case of multiple deletions we delete multiple documents in a Drop database we delete the whole database in just one command which we can do using two … Read more
Here we will discuss the difference between MySQL and NoSQL where MySQL is a structured Query Language whereas no SQL does not have any predefined structure there is no schema that well defines it where Data is stored in the form of Tables and different rows and columns in the case on MySQL which is … Read more
