coter> 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...
coter>
coter> # mysql -uroot -p homework < home1.sql
coter> Enter password:
coter> ERROR 1050 at line 9: Table 'home1' already exists
One solution is adding "DROP TABLE IF EXISTS home1;" in home1.sql.
Regards,
--Wen
[EMAIL PROTECTED]
---------------------------------------------------------------------
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