setup data type in Matlab to export in SQL

2 次查看（过去 30 天）
yogan Sganzerla
yogan Sganzerla 2021-6-4
回答： Vimal Rathod 2021-6-13
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:

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

采纳的回答

Vimal Rathod
Vimal Rathod 2021-6-13
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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by