Your script likely includes a CREATE TABLE statement that is tripping on
the fact the table already exists. The table can be deleted using the
DROP TABLE statement:
mysql> drop table home1;
You might consider adding the DROP TABLE IF EXISTS to the script as well.
Please see the MySQL Manual:
http://www.mysql.com/doc/D/R/DROP_TABLE.html
On Tue, 27 Feb 2001, Cote, Ronald wrote:
> Good Morning,
>
> Can someone tell me how to delete tables with MYSQL Version 3.23?
> I have a database named homework, with 5 tables in it. (Home1, home2,
> home3, etc...) I have cleared the databases, and they are empty. But
> when I try to run my script to repopulate Home1... I get the
> following...
>
> # mysql -uroot -p homework < home1.sql
> Enter password:
> ERROR 1050 at line 9: Table 'home1' already exists
> [root@acct101 sql]#
>
> My script is very simple, and it worked last semester. I am hoping if
> I delete the table completely... This will solve my problem.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php