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

2012 5 30
0 个回答
3 次查看（30 天）

0 个投票

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 个评论
显示 2更早的评论 隐藏 2更早的评论

Oleg Komarov
Oleg Komarov 2012-5-30
Do you want to insert or update (change) some values?
Walter Roberson
Walter Roberson 2012-5-30
It gave an error when you defined b, even though you update() passing in "a" and not "b" at all ??
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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

提问:

Shiza
Shiza
2012-5-30

Community Treasure Hunt

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

Start Hunting!

Translated by