Question

query->prepare("INSERT INTO businessweek (id, source, date, headline, body) VALUES (NULL, ?, ?, ?, ?)");
query->bindValue(1, "source");
query->bindValue(2, "date");
query->bindValue(3, "headline");
query->bindValue(4, "body");

if (query->exec()) {
    tt << "Query success";
} else {
    qDebug() << db.lastError();
    return;
}

I m 采用QMYSQL。错误是

 QSqlError(-1, "", "")

但

query->exec("INSERT INTO businessweek (id, source, date, headline, body) VALUES (NULL,  google ,  may 0, 23 ,  head ,  fjsdflksjdlkfdsjlfkjd );")

工作罚款。

Answer 1

很难想象这一问题。但是,我可以想象的一件事,当然与你的代码不符的是,从0时起(见。

因此,我建议尝试

query->prepare("INSERT INTO businessweek (id, source, date, headline, body) VALUES (NULL, ?, ?, ?, ?)");
query->bindValue(0, "source");
query->bindValue(1, "date");
query->bindValue(2, "headline");
query->bindValue(3, "body");

if (query->exec()) {
    tt << "Query success";
} else {
    qDebug() << db.lastError();
    return;
}

友情链接