Remove tables from a db

They have: 13 posts

Joined: Oct 2006

I want to remove all tables prefixed with modtesting_ from a mysql db, how can I do this with phpmyadmin?

Greg K's picture

He has: 2,145 posts

Joined: Nov 2003

If you have less than maybe 20 and they are all in the same database, on the left side, click on the DATABASE, to display all the tables in the main frame. they are sorted by name, so all the ones starting with modtesting_ should be together, just choose them all and at the bottom choose WITH SECELTED -> DROP

-Greg

They have: 13 posts

Joined: Oct 2006

Well is there a query for it? As in a query you enter by clicking on the SQL tab?

He has: 113 posts

Joined: Jul 2005

you can use the drop table sql query to drop a table. I've never used it to drop tables with wildcards and prefixes before tho but it should be possible.

They have: 36 posts

Joined: Sep 2006

go into phpmyadmin..click on the database youwant from the drop down list on the left then click the browse tab you will then have check boxes on the left clcik the ones youwant to drop then from the drop down box bottom middle just drop them....... I can help if yuor stuck

Mark

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.