Welcome to WebmasterWorld Guest from 54.211.62.139

Forum Moderators: phranque

Message Too Old, No Replies

deleting databases and tables in phpMyAdmin

sorry if this is the wrong forum...

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

Junior Member

10+ Year Member

joined:Nov 22, 2003
posts:69
votes: 0


I must be missing something, how do I do it? I have loads of stuff I don't use anymore
9:14 pm on July 7, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 29, 2002
posts:1954
votes: 0


drop the tables
9:26 pm on July 7, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Nov 22, 2003
posts:69
votes: 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?
9:29 pm on July 7, 2005 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12541
votes: 1


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.

9:33 pm on July 7, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 27, 2001
posts:2548
votes: 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".