Drop all table where

[madcrazy1]

what is the correct sql query to:

drop all tables where row count=0

 

Thank you

[madcrazy1]

Sorry: PHP Version 5.2.2

 

 

[blacknight]

    $username="root";
    $password="mypassword";
    $database="mydatabase";
    mysql_connect('localhost',$username,$password);
    mysql_select_db($database) or die( "Unable to select database");
    
    function drop_empty_tables(){
        $tables = mysql_query('SHOW TABLES');
        while($table = mysql_fetch_array($tables)){
            $table = $table[0];
            $records = mysql_query("SELECT * FROM $table");
            if(mysql_num_rows($records) == 0){
                mysql_query("DROP TABLE $table");
                echo "DROP TABLE $table;\n";
            }
        }
    }
    
    drop_empty_tables();

 

any table on the server the user has rights to with 0 row count will be droped

[madcrazy1]

Thank you. It worked nicely!