Creating a New Database Instance

Database Environment: MySQL

Database Instance

Table

CREATE DATABASE stargate

CREATE DATABASE IF NOT EXIST stargate

Before you can add anything to your database environment you must create a Database instance and give it a name

Your Database environment can support multiple Databases simaltaneously

There are 2 approaches to creating a new database instance

Just Create the Database, Will error out if a database with the same name already exist

Only create the Database if a Database with that name does not exist in the environment

Risky

Safe