Anybody have a script that creates table from sqlite table?

It would be great to be able to create a MATLAB table from a sqlite table, including column names, etc. Similar to how MATLAB imports csv files. I have the database toolkit, and can get the table data, but it doesn't have column names. Would like to be able to get the column name automatically.

Thanks.

Answer 1

[Gurpreet Singh]

Hi Brian,

The following link might help you.

https://in.mathworks.com/matlabcentral/answers/352546-create-table-query-using-sqlite

[Brian]

Not really, I know how to make an unnamed table using "cell2table(fetch(conn,'SELECT * my_table))" but it would be better if could have MATLAB automatically name all the tables based on the sqllite table info.