1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

MYSQL - Possible To Delete Multiple Tables At Once?

Discussion in 'MySQL' started by webinv, Dec 3, 2005.

  1. #1
    Hello,
    SEMrush
    Does anybody know of away to "uninstall" tables that were installed by a program such as mambo cms...

    It is so simple to add tables to a database and I know how to manually "drop" (delete) the tables, but how do I select MORE than one table at at time to delete?

    Can I run some sort of mysql query that will delete certain tables?

    Thanks for any help.

    -Jon
     
    webinv, Dec 3, 2005 IP
    SEMrush
  2. tflight

    tflight Peon

    Messages:
    617
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Certainly, with a comma separated list of the certain tables you want to drop:

    DROP TABLE table1, table2, table5, table7;
     
    tflight, Dec 3, 2005 IP
    webinv likes this.
  3. yangyang

    yangyang Banned

    Messages:
    757
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Don't your host install phpmyadmin for your database administration? In phpmyadmin, just overall check all tables and select drop. However it's just like what tflight said in essence.

    One MySQL query to end them all!
     
    yangyang, Jan 1, 2009 IP