Mysql/CheatSheet

Databases

• Create

CREATE DATABASE [IF NOT EXISTS] database_name;

• Use

USE database_name;

• Delete

DROP DATABASE [IF EXISTS] database_name;

• List all

SHOW DATABASE;

Tables

• list

SHOW TABLES;

• create

CREATE TABLE [IF NOT EXISTS] table_name(
  column_list
);