Export SQLite database to .mat(.m) file

2 次查看（过去 30 天）
Altaf Shaikh
Altaf Shaikh 2017-5-2
评论： Abraham Sherura 2018-8-11
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 个评论
显示 1更早的评论
Altaf Shaikh
Altaf Shaikh 2017-5-3
Sorry it was my mistake I want to convert this into .mat file instead .m file .
a) Why would you want to convert one to the other?
I stored value into Sqlite database and they are calculated in numeric.
Actually this file support to third party application.
b) How are you planning to map from one to the other?
I want map this data in below way:
; [Match ID "-509201106"]
; [Player 1 "dummy1"]
; [Player 2 "dummy2"]
1) 52: 24/22 13/8 5: 13/3*
2) 43: Bar/22* 13/9 6: Bar/22 24/21 6/3*(2)
3) 43: Bar/21 24/21 7: 24/16*
4) 66: Cannot Move 8: 16/11 13/11
Jan
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?

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2017-5-3
编辑：Guillaume 2017-5-3
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
Altaf Shaikh 2017-5-9
编辑：Altaf Shaikh 2017-5-9
Thanks for your support . I had figured out by creating text file at run time with some mat predefined mapping format.
Abraham Sherura
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 个）

类别

在 Help Center 和 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