Mysql databases store data in tables.
For storage of data in the database is necessary that it contains at least one created MySql table.


Delete (drop) MySql table

The drop table command is used to delete a table and all rows in the table.
Warning: Dropping the table is potentially a very bad thing to do. Any data stored in the table will be destroyed.




<?php
$dbhost = "localhost";
$dbuser = "yourusername";
$dbpass = "yourpassword";
$dbname = "yourdatabase";
$conn = mysqli_connect($dbhost, $dbuser, $dbpass , $dbname);
if (!$conn) {
    die("Connection failed: " . mysql_connect_error());
}
$sql = "DROP TABLE members";
if (mysqli_query($conn, $sql)) {
    echo "Table members deleted successfully";
} else {
   die("Could not delete table: " . mysql_error());
}
mysqli_close($conn);
?>




Privacy Policy