How to define the type of variables that will be exported to SQL in Matlab

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.

Answer 1

[Suresh Siripuram]

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.

For more information please check the documentation here.

Thank you,

Suresh