mysql - 在外键中插入数据时出错？

Question

我正在尝试将数据插入到 SQL 表中，userID 是一个 smallint，它是一个外键。金额只是一个小数点。

出于某种原因，我遇到了一个错误，我的处理方式是否正确？谢谢

SET FOREIGN_KEY_CHECKS=0
INSERT INTO donations (userID, amount) VALUES ('10', '11')
SET FOREIGN_KEY_CHECKS=1

Error: #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 'INSERT INTO donations (userID, amount) VALUES ('10', '11') SET FOREIGN_KEY_CHEC' at line 2

我的 PHP 将其插入

        //set feedback
        $sql = "SET FOREIGN_KEY_CHECKS = 0;

            INSERT INTO donations (userID, amount)
            VALUES ('30', '0');

            SET FOREIGN_KEY_CHECKS = 1;";

我也试过这个

        //set feedback
        $sql = "SELECT donations SET FOREIGN_KEY_CHECKS = 0;

            INSERT INTO donations (userID, amount)
            VALUES ('30', '0');

            SET FOREIGN_KEY_CHECKS = 1;";

Answer 1

语法看起来不错。在每行的末尾放置一个分号来分隔语句:

SET FOREIGN_KEY_CHECKS = 0;

INSERT INTO donations (userID, amount)
    VALUES ('10', '11');

SET FOREIGN_KEY_CHECKS = 1;