清空筛选条件
清空筛选条件

Info

此问题已关闭。 请重新打开它进行编辑或回答。

export a matrix from Matlab to SQL with correct ype of variables.

1 次查看（过去 30 天）
Yogan Sganzerla
Yogan Sganzerla 2020-10-29
关闭： MATLAB Answer Bot 2021-8-20
Dear all,
I have a code that Is attached which the aim is to create a matrix with specific type of variable in each Column.
The code is working perfectly and it is saving the matrix in my data base. However, as you can see in the image below, the type of the variable is missing. For example the id should be real nunbers i.e.[1;2;3;4..]
How can I define this parameter in Matlab? I already tryed to define the first colums as reeal but when I export to SQL it change again.

此问题已关闭。

回答（1 个）

Eshaan Shah
Eshaan Shah 2020-11-11
Hi,
The function sqlwrite provides a way to specify column types when inserting data into a table. Please refer to this example from the sqlwrite doc.
From the example:
tablename = 'toyTable';
coltypes = ["numeric" "numeric" "numeric" "numeric" "varchar(255)"];
sqlwrite(conn,tablename,data,'ColumnType',coltypes)

此问题已关闭。

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by