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.
Write a query to find second highest salary inMySql . This question is mostly asked in an interviews and it’s also a bit tricky. In this tutorial, We are going to learn three easiest ways to write a MySql query to find second highest salary.
What’s the difference between inner join and left join in MySql? In relational databases (Such as MySql etc.) concept of join is very important. In this tutorial, I am going to explain inner join and left join with examples.
How to connect MySql database using PHP. PHP provides inbuilt functions to connect to MySql database using their extensions. In this post, I’ll explain how to connect MySql Database using PHP.
In PHP, you can connect MySql database using following extensions.
MySql is one of the most used open-source database. In this article, i try to cover some of the most asked mysql interview questions.
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.
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 Install and Remove phpMyAdmin 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.
How to reset auto-increment value of a column in MySql.
In MySQL, we can define a column as primary key with an auto-increment index. Every time a new row is inserted it increments the value by 1. By default, an auto-increment column is a primary key of a table.