Multi table drop

Anon

Hi.
I have a table with about 76 tables, most of these I generated by accident! Is there a SQL command that enables me to drop multiple tables within one DB?

Eg. DELETE FROM db_name LIMIT 0,76;

(Obviously the above command doesn't work so I'd appreciate any help) Thanks.

[deleted]

What exactly do you have 76 of, tables in a database of columns in a table?

Either way, no database will let you drop tables or columns in tables without specifying which tables or columns to drop.

You must either drop them all by hand, or make a backup of the tables you want to keep, drop the database (which will erase all tables and columns) and then restore the tables you wanted to keep.

But before you do anything I suggest you look at an SQL manual and read a lot more about the SQL language and how to create and remove tables and columns.

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

Anon

Damn...no its 76 tables in the DB...
Im gonna hate doing it manually lol

[deleted]

You can always write a script that reads the database-schema, works out which tables exists, and drops all except the few that you want to keep.

If the database is not that big (not many records) you can make an ASCII dump of it, and use a texteditor to remove the unwanted tables from it. Then you can drop the database, re-create it, and use the SQL dump to restore the tables.

Which database type do you use? (mysql/postgres/oracle/...)

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

Anon

I am using MySQL...but using the phpMyAdmin, I still can't figure out how to ASCII dump.

[deleted]

PHPMyAdmin is not the right tool for the job, because it often makes mistakes while creating the dump.

If you can get command-line access, you can use mysqldump, check the manual form more details on how to use that.

Anon

You can use a tool such as MySQLFront (http://www.anse.de/mysqlfront/) which will allow you to create a dump of selected tables from within the database. You can then drop the DB and reload your selected dump.

Basically the same as everyone else has said without text editing...
Jules...