Hello I am trying to update my SQLite database using the following command
insert(conn, 'ClosePriceTable', {'Dates','AUD_CAD', 'AUD_CHF'}, Table_New_datax(2:end,:))
However I rather want to update only if new records are different to current records. Thus I do not want duplicate records in my SQLite database. If the new records are the same as current records then I merely wish to overwrite and not insert the same record again.
The key variable differentiating records is the date.
How can I avoid duplication of records? What command can I use?