MATLAB Answers

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

조회 수: 2(최근 30일)
Charles 28 Sep 2017
답변: Jatin Waghela 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

댓글을 달려면 로그인하십시오.


Jatin Waghela
Jatin Waghela 2 Oct 2017
Please refer to the below documentation link which gives more information on deleting data from the database using MATLAB.

  댓글 수: 0

댓글을 달려면 로그인하십시오.


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by