Monday, May 18, 2020

Answer for COMMIT doesn't work

https://365datascience.com/dwqa-answer/answer-for-commit-doesnt-work/ -

Hi Yunfeng!

Thanks for reaching out.

In this case, we are talking about statements that create an implicit commit. Triggers are on the list.
In other words, the execution of certain statements (and hence, their queries), affect the state of the database directly, so to speak, even without explicitly executing a COMMIT; statement afterwards. 

You can consult the following page from the documentation for more information. Thank you.
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html

Hope this helps.
Best,
Martin




#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy

No comments:

Post a Comment