# +----------------------------------------------------------------------------+ # | Jeffrey M. Hunter | # | jhunter@idevelopment.info | # | www.idevelopment.info | # |----------------------------------------------------------------------------| # | Copyright (c) 1998-2009 Jeffrey M. Hunter. All rights reserved. | # |----------------------------------------------------------------------------| # | DATABASE : MySQL | # | FILE : cr_database.sql | # | CLASS : Create Database Scripts | # | PURPOSE : Used to create a new MySQL database with a given name. | # | The syntax for the create database command is: | # | | # | CREATE DATABASE [IF NOT EXISTS] db_name | # | | # | An error occurs if the database already exists and you didn't | # | specify IF NOT EXISTS. | # | | # | Databases in MySQL are implemented as directories containing | # | files that correspond to tables in the database. Because there | # | are no tables in a database when it is initially created, the | # | CREATE DATABASE statement only creates a directory under the | # | MySQL data directory. | # | NOTE : As with any code, ensure to test this script in a development | # | environment before attempting to run it in production. | # +----------------------------------------------------------------------------+ create database jhunter_db;