express-generator连接mysql使用查询语句时，时间字符串怎么传递？

Question

如题，怎么传递字符串中的空格，这里会自动转换成+号

newval = newval.replace(/s+/g,"%20").replace(/:/g,"%3A")
这样处理后也查询不了，会报错

Answer 1

router.get('/mysqlInsert', function(req, res, next) {
    var newval = '"'+req.query.word+'",'+req.query.type+',"'+req.query.time+'","'+req.query.uuid+'"';
    connection.query('INSERT INTO yulu (word,type,time,uuid) value ('+newval+')', function (error,results,fields) {
        if (error) throw error;
        res.json(results);
    });
});