运行 sql DELETE 查询但不在数据库中执行的 php 命令

Question

我在 php 中写了这个 MYsql DELETE 函数

function DeleteProduct($thisCatalog) {

    $connB = new ProductDAO();
    $connB->Connect();
    $pro_query = "DELETE * FROM Ikea WHERE `CatalogNumber` = $thisCatalog";
    $db_result = $connB->ExecSQL($pro_query);

    $html_result = 'Your Product Has Been Deleted! ';

    $connB->Disconnect();
    return $html_result;
}

这是执行命令

DeleteProduct($CatalogNumber);

Answer 1

删除语法与选择语法不同(您根本不需要选择列名或在其中使用 *):

"DELETE FROM Ikea WHERE `CatalogNumber` = $thisCatalog";

应该可以解决问题。

还有一些来 self 的测试数据库的例子:

mysql> select * from first;
+------+-------+
| id   | title |
+------+-------+
|    1 | aaaa  |
|    2 | bbbb  |
|    3 | cccc  |
|    4 | NULL  |
|    6 | gggg  |
+------+-------+
5 rows in set (0.00 sec)

mysql> insert into first values (7, 'cccc');
Query OK, 1 row affected (0.01 sec)

mysql> select * from first;
+------+-------+
| id   | title |
+------+-------+
|    1 | aaaa  |
|    2 | bbbb  |
|    3 | cccc  |
|    4 | NULL  |
|    6 | gggg  |
|    7 | cccc  |
+------+-------+
6 rows in set (0.00 sec)

mysql> delete from first where id=7;
Query OK, 1 row affected (0.01 sec)

mysql> select * from first;
+------+-------+
| id   | title |
+------+-------+
|    1 | aaaa  |
|    2 | bbbb  |
|    3 | cccc  |
|    4 | NULL  |
|    6 | gggg  |
+------+-------+
5 rows in set (0.00 sec)