phpDrop all Mysql tables in a specific database
$mysqli = new mysqli('localhost', 'user', 'pass', 'dbname');
$mysqli->query('SET foreign_key_checks = 0');
if ($result = $mysqli->query("SHOW TABLES")) {
while($row = $result->fetch_array(MYSQLI_NUM)) {
$mysqli->query('DROP TABLE IF EXISTS '.$row[0]);
echo $row[0] . "\n";
}
}
$mysqli->query('SET foreign_key_checks = 1');
$mysqli->close();ctrl + cmysqliMysql driver for PHP | SET foreign_key_checks = 0disable key checks so we can drop tables one by one |
SHOW TABLESlist all tables | fetch_array(MYSQLI_NUM)fetch row as a numbered array |
'DROP TABLE IF EXISTS '.$row[0]drops selected table | SET foreign_key_checks = 1enable key checks after all tables were deleted |
More of Php
- Get Command Line Input Mid-Runtime
- How to change color of CLI text
- Insert element to an array on a certain position
- Format number with leading zeros
- Foreach all alphabet letters
- Get file extension
- Send PUT curl request
- Enable errors display
- Get free space on disk
- Remove a directory that is not empty
See more codes...