MyISAM vs InnoDB – Difference Between MyISAM and InnoDB Storage Engines

MyISAM vs InnoDB. What’s the difference between MyISAM and InnoDB storage engine. No doubt, MySql is one of the most used databases worldwide. The great thing about MySql is the flexibility to choose storage engines.

In MySql, every storage engine is designed for a specific purpose to address/solve application problems. The two popular storage engines of MySql (MyISAM and InnoDB) are widely used worldwide. So let’s check what’s the difference between MyISAM and InnoDB storage engines.

How to Select NULL Values in MySql

How to select null values in MySql. Misunderstanding NULL is a common mistake beginners do while writing a MySql query. While writing a query in MySql most of them compare column name with NULL. In MySql NULL is nothing or in simple word it is an Unknown Value so if you use comparison operator for NULL values you’ll get an empty result.

In this tutorial, We are going to learn how to write a query to select NULL values in MySql.

MongoDB Driver for PHP – Install and Connect

MongoDB is an open-source leading NoSql database. In my previous posts , I explain the MongoDB terminology, installation process,creating and quering DB. In this article i will explain how to install and connect MongoDB with PHP.

Let’s quickly go through the popular terminology used in MongoDB

MongoDB Tutorial Part- I – Creating a Database

mongoDBMongoDB is an open-source document-oriented database. Document-oriented means it stores the data in a file. MongoDb comes under the category of NoSql database. It stores the data in BSON (Binary JSON) format. It can be accessed through javascript notation and comes with their own shell. It is written in C++.