Anybody have a script that creates table from sqlite table?

Question

Brian 2020-7-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/557878-anybody-have-a-script-that-creates-table-from-sqlite-table

评论： Brian 2020-7-1

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Gurpreet Singh 2020-7-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/557878-anybody-have-a-script-that-creates-table-from-sqlite-table#answer_459634

Hi Brian,

The following link might help you.

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Brian 2020-7-1

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.

请先登录，再进行评论。