在INSERT语句Web-Sql之后获取受影响的行

Question

我是web-sql的新手。我想在INSERT语句之后检索插入的行

var db = openDatabase('fileuploader', '1.0', 'my first database', 2 * 1024 * 1024);
tx.executeSql('CREATE TABLE IF NOT EXISTS user (username unique, time)');
tx.executeSql('INSERT INTO user (username, time) 
         VALUES (?, ?)',
         [user.name , user.time],
         function(tx, results){
             console.log(results);
        });
});

如何获取最后插入的行

Answer 1

如果您像这样创建表-sql将创建一个名为rowid的列。这是此表的主键。您可以执行以下操作：

var db = openDatabase('fileuploader', '1.0', 'my first database', 2 * 1024 * 1024);
tx.executeSql('CREATE TABLE IF NOT EXISTS user (username unique, time)');
tx.executeSql('INSERT INTO user (username, time) 
         VALUES (?, ?)',
         [user.name , user.time],
         function(tx){
             tx.executeSql('SELECT * FROM user WHERE rowid = (SELECT MAX(rowid) FROM user)',
                function(tx, results){
                  console.log(results);
                });
        });
});