database transaction

If I'm using a mysql client(eg. squirrel) to execute an update query, after 10 seconds, I cancelled the query, would there be partial update or would everything that's done be rolled back?

Answers


You may want to review the MySQL documentation on BEGIN TRANSACTION, COMMIT, AND ROLLBACK.

I believe it is going to depend upon the engine you choose (e.g., InnoDB) and I saw the following comment about ROLLBACK:

If you issue a ROLLBACK statement after updating a nontransactional table within a transaction, an ER_WARNING_NOT_COMPLETE_ROLLBACK warning occurs. Changes to transaction-safe tables are rolled back, but not changes to nontransaction-safe tables.


If your query is enclosed within a Transaction block, and if you stopped it in the middle, everything would be rolled back.


If MySql has any claims of being a real database it would roll everything back, even more so for a single update statement.


Need Your Help

How to post a simple Java mathematical calculation app on a cpanel linux hosted wordpress website?

java linux wordpress

I have just started learning Java programming (Yes, I am an absolute beginner and use Java only in the training institute) and I want to post a simple Java calculation app on a cPanel Linux hosted

How can I add dll to the GAC?

.net-4.0 gac gacutil

running gacutil.exe /i ProjectX.Core.dll, I got the message: Assembly sucessfully added to te cache, but I can't see this assembly in the c:\windows\assembly folder.