MATLAB Answers

0

updating an sql lite database on my macbook delete and insert

Asked by Charles on 28 Aug 2017
Latest activity Commented on by Charles on 31 Aug 2017
Hi I wish to update an SQL Lite database file in Matlab on my macbook I understand sql lite has limitations. The replace function does not work. It seems I can merely insert.
The sql lite database already exists. My workflow is
1. retrieve new data for previous 2 period and latest period into Matlab from external data source as a cell array. Thus I will have three rows of data
2. Delete last three rows of data in designated table.
3. insert new data (3 rows) into designated table.
Is there a replace function I can use, or can I really only use insert
my syntax for insert looks like so, where VolumeTable is the designated table, and New_datavoldt is the new data I wish to insert
insert(conn, 'VolumeTable', {'Dates','AUD_CAD', 'AUD_CHF','AUD_HKD','AUD_JPY'}, New_datavoldt(2:end,:))
How do I delete the last three rows before Insert, and is this the best way to achieve mt objective using an SQL Lite file/database

  0 Comments

Sign in to comment.

1 Answer

Answer by Abhisek Roy on 31 Aug 2017

The MATLAB interface to SQLite supports the insert function only. https://www.mathworks.com/help/database/ug/inserting-data-using-command-line.html
Please refer the following document that describes about how to insert data from MATLAB into the SQLite database- https://www.mathworks.com/help/database/ug/insert.html

  2 Comments

Hello. Thanks for this. Most kind
Are there other options as I need full functionality

Sign in to comment.