NodeJs中SQL有效查询的“code”：“er_parse_error”,“errno”：1064

Question

“code”：“er_parse_error”,“errno”：1064,“sqlmessage”：“您的SQL语法中有错误；请查看与您的MySQL服务器版本相对应的手册，以便在'set@last_id_in_users=LAST_INSERT_ID()；INSERT INTO sale_targets(user_id,mon'at line 1”,“sqlstate”：“42000”,“index”：0,

NodeJs在一个有效的查询上向我抛出这个错误。它肯定是有效的，因为在phpmyadmin中它可以成功地工作。请帮帮我.

或者使用LAST_INSERT_ID()一个接一个地使用多个insert的替代解决方案。

BEGIN;
INSERT INTO users (email, first_name, last_name, password, role_id) values ("[e-mail]", "test", "test", "$2b$10$dGZ0NArlvpE7M3J4SEuW4eXrDLR4/w218mdftB0eNuJInV6BS7V2.", 3); 
SET @last_id_in_users = LAST_INSERT_ID(); 
INSERT INTO sale_targets (user_id, monday, tuesday, wednesday, thursday, friday, saturday, sunday) VALUES(LAST_INSERT_ID(), '0', '0','0','0','0','0','0'); 
INSERT INTO close_ratio (user_id, monday, tuesday, wednesday, thursday, friday, saturday, sunday) VALUES(@last_id_in_users,'0', '0','0','0','0','0','0'); 
INSERT INTO lead_targets (user_id, monday, tuesday, wednesday, thursday, friday, saturday, sunday) VALUES(@last_id_in_users,'0', '0','0','0','0','0','0'); 
COMMIT;

我的节点查询连接：

    const q = `BEGIN; INSERT INTO users (email, first_name, last_name, password, role_id) 
values ("${rBody.email}", "${rBody.firstName}", "${rBody.lastName}", "${hash}", ${roleId}); 
SET @last_id_in_users = LAST_INSERT_ID(); 
INSERT INTO sale_targets (user_id, monday, tuesday, wednesday, thursday, friday, saturday, sunday); 
VALUES(LAST_INSERT_ID(), '0', '0','0','0','0','0','0'); 
INSERT INTO close_ratio (user_id, monday, tuesday, wednesday, thursday, friday, saturday, sunday) 
VALUES(@last_id_in_users,'0', '0','0','0','0','0','0'); 
INSERT INTO lead_targets (user_id, monday, tuesday, wednesday, thursday, friday, saturday, sunday) VALUES(@last_id_in_users,'0','0','0','0','0','0','0'); 
COMMIT`;
                    connection.query(q, (err, resp) => {
                        if (err) {
                            // Error inserting into users table
                            resolve({
                                success: false,
                                error: err
                            })
                        } else {
                            // User succesfully created
                            resolve({
                                success: true,
                                message: 'User succesfully created',
                                id: resp.insertId
                            })
                            console.log(resp)
                        }

                    })

Answer 1

SET@last_id_in_users=SELECT LAST_INSERT_ID()；