MATLAB Answers

updating an sql lite database on my macbook delete and insert

4 views (last 30 days)
Charles on 28 Aug 2017
Commented: 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


Sign in to comment.

Answers (1)

Abhisek Roy
Abhisek Roy on 31 Aug 2017
The MATLAB interface to SQLite supports the insert function only.
Please refer the following document that describes about how to insert data from MATLAB into the SQLite database-

Community Treasure Hunt

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

Start Hunting!

Translated by