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.
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.