Export SQLite database to .mat(.m) file
显示 更早的评论
Hi Guys,
I am new at this forum and I want some help regarding a convert SQLite database into .m(matlab) file for support matlab editor as well that getting easy to understand. Would you please tell me how I convert my database(SQLite) file into .m file ? Is it direct support or shall I create first excel or in other format ?
Thanks in advance!
3 个评论
Guillaume
2017-5-2
A database (SQLite or other) mostly consists of tables, possibly some stored queries and maybe more.
An .m file consists of program instructions.
The two are not alike. So:
a) Why would you want to convert one to the other?
b) How are you planning to map from one to the other?
Altaf Shaikh
2017-5-3
Jan
2017-5-3
The question is not clear. How exactly can the input file be access and what do you want as output file?
采纳的回答
If you have the database toolbox, importing all rows of a table from an sqlite file is trivial:
conn = sqlite('yourdbfile.db');
tabledata = fetch(conn, 'SELECT * FROM sometable');
You can do that for all the tables, if that's what you mean by converting the database to a mat file. You will, of course, be missing a lot of what constitutes a database, the schema, triggers, views, indexes, etc. which I'm not sure how you'd store in a mat file.
2 个评论
Altaf Shaikh
2017-5-9
编辑：Altaf Shaikh
2017-5-9
Abraham Sherura
2018-8-11
Hey Altaf, do you mind taking me through how you figured it out. I am in the same mix. Trying to export an SQLite database to MATLAB. Thank you
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
