DELETE statement mysqli

Question

我对某些事情很不安全。如果我想删除数据库的整个表，下面的代码正确吗？还是我必须再添加一些代码？它需要一个while循环，还是我误解了什么？

del.php：

<form method="POST" action="del.php">
  <button type="button" name="delete" id="delete" value="Delete">
</form>
<?php
    include 'connect.php';
    $stmt = $mysqli->prepare("DELETE * FROM numbers") or die($mysqli->error);
?>

Answer 1

您可以删除通配符*，即

$stmt = $mysqli->prepare("DELETE FROM numbers") or die($mysqli->error);

Answer 2

必须是DELETE FROM numbers

$stmt = $mysqli->prepare("DELETE FROM numbers") or die($mysqli->error);

如果你想截断，你可以有

TRUNCATE [TABLE] numbers