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

3 次查看(过去 30 天)
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.

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

产品

Community Treasure Hunt

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

Start Hunting!

Translated by