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

3 次查看（过去 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.
Delete Data from Databases

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by