why not just drop the db and recreate it?

if you can do it with php, just do a 'SHOW TABLES' query, and loop through it and drop them 1 by 1.

but
DROP DATABASE db
CREATE DATABASE db

is probably faster.

    why not just drop the db and recreate it?

    I'm not MySQL server admin

      • [deleted]

      • Post #4

      Then just drop every table seperately.

      There is no command to drop all tables because who would ever want to drop all his tables at once?

        ok... so someone gave you access to drop tables but not the database that contains those tables???

        $result = mysql_query("SHOW TABLES");
        while(list($table_name) = mysql_fetch_row($result))
        mysql_query("DROP TABLE $table_name");

        that will do what you want.

          2 months later

          What you also can do is seperate them with a , . Like this:

          DROP TABLE tablename1,tablename2,table...

          etc...

          Bassie

            Write a Reply...