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. 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.
There are many times you need to concatenate the values of two or more columns while querying the result. To concatenate columns in MySql there is in-built function for that.
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
In previous two posts of MongoDB, i discussed about
1. What is MongoDB and how to install it
2. Query Document in MongoDB
In this post i am going to discuss about MongoDB operators.
In my previous post, I have discussed about MongoDb, how to install and how to create a database. In this post i am going to discuss about query document(It is like a record or row in relational databases) in MongoDB.