数据库名称:学习者,表: learner_details,列: learner_id,learner_name,learner_mail,course_id。
我只想向邮递员申请邮寄,但没有工作。
错误:
selected',sqlState:'3D000',索引: 4,sql:'SET @learner_id =NULL;SET @learner_name = NULL;SET @learner_email = NULL;SET @course_id = NULL;CALL learner_create_update( @learner_id,@learner_name,@learner_email,@course_id);‘}`
代码:
let learner = req.body;
var sql = "SET @learner_id = ?; SET @learner_name = ?; SET @learner_email =?; SET @course_id = ?; CALL learner_create_update( @learner_id, @learner_name, @learner_email, @course_id);";
mysqlConnection.query(
sql,
[learner.learner_id, learner.learner_name, learner.learner_email, learner.course_id],
(err, rows, fields) => {
if( !err )
rows.forEach(element => {
if( element.constructor == Array )
res.send('New Learner ID : ' + element[0].learner_id);
});
else
console.log(err);
})
});发布于 2020-10-08 23:14:19
你有两个选择
将数据库名称添加到连接。
var connection = mysql.createConnection({
host : 'localhost',
database : 'dbname',
user : 'username',
password : 'password',
});或者将查询添加到
use dbname;在之前运行其余的查询
https://stackoverflow.com/questions/64271791
复制相似问题