SQLite Cordova -错误处理SQL: 5

Question

var db = window.openDatabase("Database", "1.0", "userData", 200000);
console.log(db);
db.transaction(populateDB, errorCB, successCB);
function populateDB(tx) {
   tx.executeSql('CREATE TABLE IF NOT EXISTS USER (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, api_key TEXT NOT NULL, username TEXT NOT NULL)');
   tx.executeSql('INSERT INTO USER (api_key, username) VALUES ( "asd", row")');
}
function errorCB(err) {
    console.log("Error processing SQL: "+err.message);
}
function successCB() {
    console.log("success!");
}

执行第一个SQL语句，但随后第二个SQL语句返回:

could not prepare statement (1 unrecognized token: "")")  //with error code 5

。知道为什么吗?

我在这里遵循PhoneGap文档

Answer 1

您伪造了row字符串的开始引号。