setup data type in Matlab to export in SQL

Dear,

I hava a table in MATLAB that I would like to save in SQL.

In SQL the columns must have an specific type of variable, for example: the first column is "id" and it must be bigint(20).

how to set up in MATLAB my first column as bigint(20) to match with SQL table?

I tried something like int64 but the output you can see below and it is not the same:

Answer 1

[Vimal Rathod]

Hi,

You could refer to the following link for an example on specifing data type before insertion into table and there are other examples as well in that page on creating table from matlab to sql.

https://de.mathworks.com/help/database/ug/database.odbc.connection.sqlwrite.html#mw_2d08b866-0cf7-466b-9d59-cc522c6ebc1a