Am trying to create a alert condition if the duplicate value is inserted to DB on duplicate entry of data on unique state Example on my code below as test table's all columns are unique and insert query has a repeated entry of data on that i need to show sql error
Create Query
var db = openDatabase("demo", "1.0", "demo", 200000);
db.transaction(function(tx) {
tx.executeSql( "CREATE TABLE IF NOT EXISTS test (Slno INTEGER PRIMARY KEY AUTOINCREMENT, column1 TEXT UNIQUE, column2 TEXT UNIQUE, column3 TEXT UNIQUE, column4 TEXT UNIQUE, column5 TEXT UNIQUE)");
});
Insert Query
db.transaction(function(tx) {
tx.executeSql("INSERT INTO test (column1, column2 ,column3, column4,column5) VALUES ('insert1','insert2','insert3','insert4','insert5'),('insert1','insert2','insert3','insert4','insert5');");
});
Aucun commentaire:
Enregistrer un commentaire