how do I delete a duplicate record from an SQLite database using a MATLAB command
1 回表示 (過去 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.
0 件のコメント
回答 (1 件)
Jatin Waghela
2017 年 10 月 2 日
Please refer to the below documentation link which gives more information on deleting data from the database using MATLAB.
0 件のコメント
参考
カテゴリ
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!