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.
PHP provides three api to connect mysql Database.
1. MySql
2. MySqli
3. PDO
Out of these three MySql extension is deprecated as of PHP 5.5.0, and will be removed in the future.
MYSQLI is an improved object oriented extension introduced in PHP 5.
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.