matlab to SQL, AutoCommit

2012 2 6
1 个回答
更新时间：2024 9 30
4 次查看（30 天）

0 个投票

The database toolbox says, when connected, AutoCommit must be 'off', so to save data from Matlab to SQL database. I have the connection, but AutoCommit='on'. What should I do?
Thanks.

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

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-9-30

0 个投票

@Hugh,
The status of AutoCommit database flag determines whether or not the insert action can be undone.
If the AutoCommit flag is set to on, the database commits the exported data automatically to the database, and this action cannot be undone.
Check the "Insert Total Sales for One Month into Database" section of this link.
Also, to run commit function, the AutoCommit flag for connection variable must be off.
Please go through this link for more details -
https://www.mathworks.com/matlabcentral/answers/12835-what-happens-exactly-when-autocommit-is-off

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

提问:

Hugh
Hugh
2012-2-6

回答：

Piyush Kumar
Piyush Kumar
2024-9-30

Community Treasure Hunt

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

Start Hunting!

Translated by