MATLAB Answers

0

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

Asked by Charles on 28 Sep 2017
Latest activity Answered by Jatin Waghela on 2 Oct 2017
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.

  0 Comments

Sign in to comment.

Products

1 Answer

Answer by Jatin Waghela on 2 Oct 2017

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

  0 Comments

Sign in to comment.