Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

如题,nodejs 写mysql插入多行记录报错:
Column count doesn't match value count at row 1
function insert(addSql, addSqlParams) {
    let promise = new Promise(function (resolve, reject) {
        connection.query(addSql, addSqlParams, function (err, result) {
            if (err) {
                console.log('[INSERT ERROR] - ', err.message);
                return;
            }
            resolve(result);
            // connection.end();

        });
    });


    return promise;

}
// 插入sql语句
    let add_sql = "insert into detail(id,pub_date,title,url,insert_date) values ?";
    add_sql_params = [
  [
    '2020-11-05',
    '常见问题',
    'http://aaaaa.test.html',
    '2020年11月9日 周一 17时2分58秒'
  ]
]
     insert_result = insert(add_sql, [add_sql_params]);

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
2.4k views
Welcome To Ask or Share your Answers For Others

1 Answer

插入sql语句错误,忽略id字段,让其自增,如下

// 插入sql语句
    let add_sql = "insert into detail(pub_date,title,url,insert_date) values ?";

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...