php - MySQL 使用 php 创建触发器

Question

这个问题已经有答案了:

When to use single quotes, double quotes, and backticks in MySQL (13 个回答)

已关闭 6 年前。

我读过一些像我这样的其他帖子，但没有一个能解决我的问题，我有两个表，用户和购买，当用户注册时，我想将相同的 user_id 添加到购买表中。我尝试纠正这样的 php 代码:

$query = "CREATE TRIGGER `purchase_insert` AFTER INSERT ON `user` FOR EACH ROW BEGIN INSERT INTO purchase (user_id) VALUES (NEW.user_id)";

$result = mysqli_query($connection, $query);
if($result){echo "<br>TRIGGER Success!";} else {die("<br>Database query failed. " . mysqli_error($connection));}

这是我得到的错误:

Database query failed. 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 '' at line 1

如果问题重复，我很抱歉。

Answer 1

应该是反勾号而不是单引号

CREATE TRIGGER `purchase_insert` AFTER INSERT ON `user` FOR EACH ROW BEGIN INSERT INTO purchase (user_id) VALUES (NEW.user_id)

更新

试试这个

DELIMITER$$ 
CREATE TRIGGER `purchase_insert` 
    AFTER INSERT ON `user`
    FOR EACH ROW 
BEGIN
    INSERT INTO purchase (user_id) VALUES (NEW.user_id);
END$$
DELIMITER ;