MongoDB – POFTUT

Category: MongoDB

0

SQL “Select Into” Statement Usage Tutorial

SQL provides different statements in order to select into existing table, variable, temp table in various database servers like Oracle, MySQL, PostgreSQL etc. In this tutorial we will examine how to use Select Into SQL statement for different cases. Syntax Select Into statement syntax is the same as with Select syntax. We just need to a INTO between SELECT and FROM. We can also use WHERE statement in order to filter rows.

...

1

How To Dump Mongodb By Using Mongodump Tool with Examples

Mongodb provides a lot of flexibilities to the application developers and system administrators. As we know mongodb is an nosql database server. Standard Sql database servers provides different tools to dump and backup given database. Mongodb provides mongodump tool for dump and backup operations. Check MongoDB Service Status First we should check the status of the mongodb. We can use systemctl command which is provided by popular Linux distributions.

Dump MongoDb...

0

How To Install and Configure MongoDB NoSQL Database To Linux, Ubuntu, Debian, CentOS, Fedora

Sql is very powerful language to query, insert, delete, modify data. Recents years the IT industry have developed some alternative ways to store and retrieve data. NoSQL type database servers become very popular. MongoDb is an NoSQL database server to store and retrieve data. In this tutorial we will look how to install MongoDB on Linux and distributions like Ubuntu, Debian, CentOS, Fedora, RedHat. Fedora, CentOS, RedHat We will use...

0

How To Prevent SQL Injection in Php Applications?

I have an application and I have complex requests tot the server. There are a lot of database operations. Managing them can become very hard some times. In this situation how can I prevent sql injection attacks to my application. Use Prepared Statements Prepared statements are the way to bind client-side provided values with database queries. Prepared Data Object (PDO) acts middle proxy and prevents SQL injections. PDO is supported...

0

What is The Difference Between Inner and Outer Join?

Sql is the language where a lot of data can be get with different logic. In an enterprise environment we may need to use complex SQL queries to get meaningful data. Inner is one of the logic where we join two tables with different magic. Example Tables In order to understand Inner and Outer Joins we will use following example tables with their data. We will use two tables those...

Enjoy this blog? Please spread the word :)