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

2 ビュー (過去 30 日間)
Charles
Charles 2017 年 9 月 28 日
回答済み: Jatin Waghela 2017 年 10 月 2 日
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.

回答 (1 件)

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

製品

Community Treasure Hunt

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

Start Hunting!

Translated by