php - MySQL 基本触发器 - 不工作

Question

我正在尝试创建以下触发器:

CREATE TRIGGER clean
AFTER INSERT ON `mecze_druzyny`
begin
DELETE * FROM bramki;
END;
DELIMITER ;

应在以下内容之后立即运行:

$sql2 = "INSERT INTO mecze_druzyny (id_druzyny, id_meczu, gospodarz) VALUES (
        :team2, 
        :lastmatch, 
        :gospodarz)";

$stmt = $db->prepare($sql2);
$stmt->bindParam(':team2', $id2, PDO::PARAM_INT);       
$stmt->bindParam(':lastmatch', $last_match, PDO::PARAM_INT); 
$stmt->bindParam(':gospodarz', $a=0, PDO::PARAM_STR);
$stmt->execute(); 

不幸的是，我遇到了一个错误:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'begin DELETE * FROM bramki' at line 3

Answer 1

这是您的删除语法错误。

去掉 * 就剩下

从 bramki 中删除

典型的删除格式为

DELETE FROM TableName WHERE ... -- WHERE 子句在这里是可选的