我在nodejs中有一个简单的函数,可以将结果添加到MYSQL中。但是结果是以数组形式出现的,我不能正确地将此数据添加到表中。
我的函数:
function getPreviousGames() {
const previousGames = [];
let gameHash = generateHash(crashHash);
for (let i = 0; i < 1; i++) {
const gameResult = crashPointFromHash(gameHash);
previousGames.push({ gameHash, gameResult });
gameHash = generateHash(gameHash);
}
return previousGames;
}
function verifyCrash() {
const gameResult = crashPointFromHash(crashHash);
const previousHundredGames = getPreviousGames();
for (let i = 0; i < 1; i++) {
var sql = "INSERT INTO `admin_dev`.`crash_numbers` (`id`, `hash`, `multiplier`, `status`, `created_at`, `updated_at`) VALUES (NULL, '" + previousHundredGames(gameHash) + "', '" + gameResult + "', '0', now(), now());";
connection.query(sql, function (err, result) {
if (err) throw err;
console.log("Success!");
});
}
return { gameResult, previousHundredGames };
}我收到了如下结果:
{
previousHundredGames: [
{
gameHash: 'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855',
gameResult: 2.52
}
]
}并且我无法正确地将接收到的数据添加到mysql表中。
我需要从previousHundredGames value gameHash添加到hash列,并将gameResult值添加到multiplier列。
我怎样才能正确地完成它呢?
发布于 2021-04-10 14:44:22
如果使用查询,则只需构建插入查询即可。
//Start the query
let query= 'INSER INTO (hash, gameResult) VALUES ';
//Add multiple rows from the array
for (let aGame of previousGames)
query+= `( "${aGame.gameHash}", ${aGame.gameResult}), `
//Remove the last comma
query= queryBuilder.substring(0, queryBuilder.length - 1)下面是关于在单个查询中插入多行的文档。
https://stackoverflow.com/questions/67031448
复制相似问题