I have created tables in mysql using a weblog. I now realize that I need
to reinstall the plugin that I originally installed. Can someone tell me
how to delete specific table from a database?
I use phpmyadmin to manage mysql and I figured checking the check boxes
next to the tables that I want to
On Friday 03 January 2003 19:14, aman raheja wrote:
> How can I delete all tables starting with prefix 'abc' in the MySQL
> database (there
> are about 200 such tables).
> Wild cards?
Nope. You should use list of all tables in the DROP TABLE command if you want
to do it only with MySQL.
> Or if
Hi All
How can I delete all tables starting with prefix 'abc' in the MySQL database
(there
are about 200 such tables).
Wild cards?
Or if I just delete the files from the location where all the MySQL database
tables are
stored, what would happen ?
Thanks
Aman
---
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...
cote
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:
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 fol
