how to store multidimensional array in a single column in mysql database?

5 次查看(过去 30 天)
when i wrote it in this way it work fine...
a=[1];
update(conn, 'candidate', colnames, a, 'where candidate_id = 1');
but when i wrote it in this way it give the error
b=[1 2];
update(conn, 'candidate', colnames, a, 'where candidate_id = 1');
??? Index exceeds matrix dimensions.
Error in ==> database.update at 136
dataString = [ dataString fieldNames{j} ' = ' tmpstr ];
  4 个评论
Shiza
Shiza 2012-5-30
oh sorrry.... i copied the same statment 2 times
...but in matlab i go with "b" in the query...
Shiza
Shiza 2012-5-30
i want to update the value...but the problem is not with the update statment..
just the 'b' array dont work fine in the same query...

请先登录,再进行评论。

回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by