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?


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.