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.

How to Install MySql Workbench on Ubuntu

How to install MySql workbench on Ubuntu.

MySql is one of the most used databases worldwide. To manage MySql database there are a lot of open source GUI tools are available. Some of the popular GUI based tools is  MySql workbench, phpMyAdmin etc. In this tutorial, you’ll learn how to install MySql workbench on Ubuntu.

MySQL Workbench

MySQL Workbench is a GUI-based visual tool. Workbench is widely used by developers,  DBAs for data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. This tool is available for Windows, Linux and Mac OS operating system.

In this article, I’ll show how you can install MySql workbench on Ubuntu.

How to Install and Remove phpMyAdmin on Ubuntu.

PHP PDO Tutorial to Connect MySql Database

How to connect MySql Database using PHP PDO (PHP Data Objects). What’s the advantage of using PHP data objects.

PHP PDO (PHP data objects) is a database access layer providing a uniform method of access to multiple databases. PHP Data Objects is written to provide a consistent API.  Before MySqli and PDO, we used MySql API to connect MySql Database. Let’s see how PDO is better than MySql Api.