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