Tip & Tricks

MySQL storage engines 

MySQL provides various storage engines for its tables as below:

MyISAMInnoDBMERGEMEMORY (HEAP)ARCHIVECSVFEDERATED

Manage database 

To create database

CREATE DATABASE [IF NOT EXISTS] database_name;

To show all database
SHOW DATABASES;

Use Database
USE database_name;

Removing Databases
DROP DATABASE [IF EXISTS] database_name;