create database if not exists code example

Example 1: create database if not exists

CREATE DATABASE [IF NOT EXISTS] database_name;

Example 2: not exists mysql

SELECT DISTINCT store_type FROM stores
WHERE NOT EXISTS (SELECT * FROM cities_stores
                    WHERE cities_stores.store_type = stores.store_type);