Info
此问题已关闭。 请重新打开它进行编辑或回答。
How to define the type of variables that will be exported to SQL in Matlab
1 次查看(过去 30 天)
显示 更早的评论
Dear all,
I have a matlab code (following attached) that creates a table in SQL.
The code runs perfectly, but my problem is the way it is saved in SQL. As you can see in the photo below, in the id Column, I was expecting to be just real numbers( ex ID = [1;2;3;4;...] and it is the same with the other variavles. Each of them has one specific type that I wish to be able to setup in MATLAB and not in SQL.
It is possible? how to do that?
Thank you for your attention.
0 个评论
回答(1 个)
Suresh Siripuram
2020-12-2
Hi Yogan,
It is possible to do specify the column type while writing to SQL by adding a parameter ‘columnType’ and provide the data type for all columns in the database table with sqlwrite command.
Thank you,
Suresh
0 个评论
此问题已关闭。
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!