how do I delete a duplicate record from an SQLite database using a MATLAB command

Hi I have an sqlite database with records which can be identified by a datetime string. i have a duplicate entry and which to delete it. What is the Matlab command for this? I have tried the following, where conn is the connection to the database.

DELIT ='DELETE * FROM OpenPriceTable WHERE Dates = 2017-09-21T21:00:00.000000Z'

exec(conn, DELIT);

I get the following error. Note I only want to delete the duplicate. Please advise >> exec(conn, DELIT); Error using sqlite/exec Received exception (SQL error or missing database prices.db. (near "*": syntax error)) upon attempting an operation; details: DELETE * FROM OpenPriceTable WHERE Dates = 2017-09-21T21:00:00.000000Z.

Answer 1

[Jatin Waghela]

Please refer to the below documentation link which gives more information on deleting data from the database using MATLAB.

Delete Data from Databases