Database toolbox downloading individual data as cell arrays

Question

Azura Hashim 2016-7-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/296513-database-toolbox-downloading-individual-data-as-cell-arrays

回答： Azura Hashim 2016-7-22

Hi, I am using database toolbox to fetch data using MySql. However the fetched data matrix consists of individual values as cell arrays. How can I download the data as a matrix consisting as simple values? I simply want to download the entire table as a simple matrix. Thanks.

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2016-7-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/296513-database-toolbox-downloading-individual-data-as-cell-arrays#answer_229236

在 MATLAB Online 中打开

I don't have the database toolbox but I assume it returns the contents of a table as a cell array because there is no guarantee that the columns are numeric and never empty.

If you are sure that the columns are always numeric and never empty, then:

dataasmatrix = cell2mat(yourfetcheddata)