Jon Miller wrote:
>I have a sql script that needs to be re entered using the following command mysql <
> create.sql but the database already exists. IS there a way to overwrite or update the
> database using the script, or do I have to delete the existing database?
>
>
>------------------------------------------------------------------------
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META http-equiv=Content-Type content="text/html; charset=us-ascii">
><META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
><BODY style="MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px">
><DIV>I have a sql script that needs to be re entered using the following command
>
>mysql < create.sql but the database already exists. IS there a way to
>
>overwrite or update the database using the script, or do I have to delete the
>existing database?</DIV>
><DIV> </DIV>
><DIV> </DIV></BODY></HTML>
>
>
>
>------------------------------------------------------------------------
>
>
>
>
Hi Jon,
You will have to drop the database first if you wish to start from
scratch. If you wish to update the records, the syntax at
http://dev.mysql.com/doc/refman/5.0/en/create-database.html would be
useful, especially the IF NOT EXISTS bit. This will allow you to bypass
the CREATE DATABASE requirement. You may also use a similar syntax for
the CREATE TABLE statement.
Regards
--
David Logan
South Australia
when in trouble, or in doubt
run in circles, scream and shout
