删除查询在MySQL中不起作用

Question

我正在尝试从名为user_enrole的表中删除所有记录。

DELETE * FROM user_enrole

我认为查询的语法没有错，但这给了我错误提示

＃1064-您的SQL语法有误；检查与您的MySQL服务器版本相对应的手册，以在第1行的'* FROM user_enrole'附近使用正确的语法

我已经仔细检查了我的语法，但我无法找出问题出在哪里，请有人指出。

是由于该表与使用表之间的关系而发生的还是什么？

Answer 1

当您编写时SELECT * FROM...，*意味着一切，即所有字段。该行的所有部分。删除时使用相同的语法没有任何意义，因为您只能删除整行。这就是为什么语法是DELETE FROM...

Answer 2

我现在为此输入信息，因为我遇到了同样的问题。当我去给出答案时，它没有帮助。可能是因为该问题并未给出所有相关脚本的完整描述：HTML，Javascript，php等。以下是我用来从数据库表中删除的正确php脚本的结构<?php$servername = "localhost";$username = "user";$password = "0007";$dbname = "CRCSystems";// Create connection$conn = mysqli_connect($servername, $username, $password, $dbname);// Check connectionif (!$conn) {&nbsp; &nbsp; die("Connection failed: " . mysqli_connect_error());}$tblname = test_input($_POST["tblname"]);$names = test_input($_POST["names"]);&nbsp; &nbsp; function test_input($data) {&nbsp; &nbsp; $data = trim($data);&nbsp; &nbsp; $data = stripslashes($data);&nbsp; &nbsp; $data = htmlspecialchars($data);&nbsp; &nbsp; return $data;}$sql = "SELECT * FROM $tblname WHERE Names = '$names'";if (mysqli_query($conn, $sql)) {&nbsp; &nbsp; $result = mysqli_query($conn, $sql);&nbsp; &nbsp; $row = mysqli_fetch_row($result);&nbsp; &nbsp; if ($row) {&nbsp; &nbsp; &nbsp; &nbsp; $sql = "DELETE FROM $tblname WHERE Names = '$names'";&nbsp; &nbsp; &nbsp; &nbsp; $result = mysqli_query($conn, $sql);&nbsp; &nbsp; &nbsp; &nbsp; echo 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;//record deleted&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; echo 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;//record does not exist&nbsp;&nbsp; &nbsp; }}mysqli_close($conn);?>