Showing posts with label MySQL script to create and drop databases. Show all posts
Showing posts with label MySQL script to create and drop databases. Show all posts

Sunday, January 18, 2009

MySQL script to create & drop databases !!!

#===============================================================================
# FILE: alter_dbs.sql
# DESCRIPTION: To drop and recreate the databases
# AUTHOR: Parag Kalra (), paragkalra@gmail.com, www.paragkalra.com
# CREATED: Sunday 18 January 2009 07:00:29 IST IST
#===============================================================================


#-------------------------------------------------------------------------------
# Dropping the databases if they exists
#-------------------------------------------------------------------------------
DROP DATABASE IF EXISTS `some_database `;

#-------------------------------------------------------------------------------
# Creating databases
#-------------------------------------------------------------------------------
CREATE DATABASE `some_database `;