homepage Welcome to WebmasterWorld Guest from 54.211.190.232
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe and Support WebmasterWorld
Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque & physics

Webmaster General Forum

    
deleting databases and tables in phpMyAdmin
sorry if this is the wrong forum...
superbird




msg:336786
 9:13 pm on Jul 7, 2005 (gmt 0)

I must be missing something, how do I do it? I have loads of stuff I don't use anymore

 

The Contractor




msg:336787
 9:14 pm on Jul 7, 2005 (gmt 0)

drop the tables

superbird




msg:336788
 9:26 pm on Jul 7, 2005 (gmt 0)

Thanks!
Do I have to do that where I want to get rid of the whole db as well as just some of the tables?

coopster




msg:336789
 9:29 pm on Jul 7, 2005 (gmt 0)

DROP TABLE removes one or more tables.
DROP DATABASE drops all tables in the database and deletes the database. But, as the MySQL manual warns "Be very careful with this statement!" because you are going to lose everything in the database if you do!

You probably just want to DROP TABLE by the looks of your request.

physics




msg:336790
 9:33 pm on Jul 7, 2005 (gmt 0)

In phpMyAdmin it's pretty easy to do things like this. I.e. to drop a table select the database in the drop-down menu on the left. Then click on the table name you want to drop on the left. Then on the top right one of the tabs is "Drop".

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved