matlab to SQL, AutoCommit

1 次查看（过去 30 天）
Hugh
Hugh 2012-2-6
回答： Piyush Kumar 2024-9-30
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
@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

类别

在 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