grant and revoke from a user for the selected commands
note: first you must be logged in as a root user how to create a user? syntax: create user 'username'@'host_name' identified by …
Showing posts with the label dbmsShow all
HOW TO INsTALL MONGODB
note:create a folder in c: create a folder named:data create a folder named:in data folder db search :mongo db download click: MongoDB Community Ser…
NoSQLnosql with mongo db
NoSQL databases also known "not only SQL are non-tabular databases . NoSQL databases come in a variety of types based on their data model. Th…
foreign key
a foreign key in one table used to point primary key in another table. 1. first create a base table: create table persons ( …
join in sql
A JOIN clause is used to combine rows from two or more tables, based on a related column between them . SQL Join statement is used to combine data or…
