PHP to drop/clear/wipe mysql database so that all rows are deleted and the database is empty

[james909]

Hi programmers.

 

Could someone please explain to me how to clear all rows from a database so that the database is empty?

 

Thanks

[PravinS]

use TUNCATE tablename

 

or you can just export database structure and restore back overwriting the old database

 

do take backup of your old database

[Barand]

Something like this

$db = new mysqli(HOST,USERNAME,PASSWORD,'databasename');

$sql = "SHOW TABLES";
$res = $db->query($sql);
while ($row = $res->fetch_row()) {
    echo "$row[0]<br>";
    $sql2 = "TRUNCATE TABLE `$row[0]`";
    $db->query($sql2);
}