HELP PLEASE! How to insert arrays 1x24 in columns of a database sql?

Question

Andrés Felipe Fontalvo Mejia 2020-3-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/511934-help-please-how-to-insert-arrays-1x24-in-columns-of-a-database-sql

编辑： Andrés Felipe Fontalvo Mejia 2020-3-20

Hello guys, how are you? (I speak spanish)

I need inserts 4 arrays 1x24 at the same time in a database but have an error

 %% INSERT TO DATABASE SQL
     columns = {'FechaHora,Presion,Volumen,Energia,id_Distribucion,RangoOperacional,Valido'};
     dato = {x1,x2,x3,x4,id3,RangoOp,Valido}; %%ARRAYS 1X24 WITH VARIOUS DATA (X1 IS STRING - DATETIME) (X2,3,4 ARE DOUBLES) 
     insert(conn2,'dbo.Datos',{columns},{dato});
     exec(conn2,query2);

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2020-3-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/511934-help-please-how-to-insert-arrays-1x24-in-columns-of-a-database-sql#answer_421096

Your columns input is completely wrong. It's a cell array with just one cell, a very long char vector. You then wrap that into another cell array when calling insert. Correct syntax should be:

 columns = {'FechaHora', 'Presion', 'Volumen', 'Energia', 'id_Distribucion', 'RangoOperacional', 'Valido'};
 dato = {x1,x2,x3,x4,id3,RangoOp,Valido}; %%ARRAYS 1X24 WITH VARIOUS DATA (X1 IS STRING - DATETIME) (X2,3,4 ARE DOUBLES) 
 insert(conn2,'dbo.Datos', columns, dato);
 exec(conn2,query2);