Ionic Cordova SQLite，如果不存在则插入数据，如果数据存在则替换旧数据(Ionic Cordova SQLite, insert data if not exists, if data exists replace the old data)

 我正在用Ionic和Cordova SQLite开发一个应用程序。 如果sqlite中不存在数据，但是如果数据存在于sqlite中，则应用程序将数据插入到sqlite中。 然后，应用程序正在替换旧数据。 以下是我的代码。 但我无法将数据插入到sqlite数据库中。 
 
 创建数据库 
 
db = window.openDatabase("chatChannel.db", "1", "Demo SQLite Test", "2000");
$cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS chat_channel(id interger primary key, channel_name text unique, last_text text)")
 
 插入数据 
 
  var query = "INSERT INTO chat_channel (channel_name, last_text) VALUES(?,?) ON DUPLICATE KEY UPDATE (last_text) VALUES (?)";
  $cordovaSQLite.execute(db, query, [channel, $scope.messageContent], [$scope.messageContent]);
 
 如果sqlite数据库中不存在记录，我是否知道如何将数据插入cordova s​​qlite;如果数据库中存在数据，则更新数据。 

I am developing an application with Ionic and Cordova SQLite. The application is inserting data into sqlite if data is not exists in sqlite but if data exists in sqlite. Then, application is replacing the old data. The following is my code. But I can't insert data into sqlite database.
 
Create Database
 
db = window.openDatabase("chatChannel.db", "1", "Demo SQLite Test", "2000");
$cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS chat_channel(id interger primary key, channel_name text unique, last_text text)")
 
Insert Data
 
  var query = "INSERT INTO chat_channel (channel_name, last_text) VALUES(?,?) ON DUPLICATE KEY UPDATE (last_text) VALUES (?)";
  $cordovaSQLite.execute(db, query, [channel, $scope.messageContent], [$scope.messageContent]);
 
May I know how to insert data into cordova sqlite if record not exist in sqlite database and update data if data is exists in database.

原文：https://stackoverflow.com/questions/39764826