Bryan Koschmann - GKT <[EMAIL PROTECTED]> [2004:01:05:18:58:12-0800] scribed: <snip />
> Here is the explanation I just received when asking for the difference > between transaction support: > > --------- > MySQL uses single-action implicit and explicit transactions, but they do > not > automatically roll back on failure. > > SQL Server user single action implicit and batch explicit transactions as > well as supporting transaction nesting (transactions inside of parent > transactions) and on failure the entire batch and any parent / peer > transactions are rolled back. <http://www.mysql.com/doc/en/InnoDB.html> <http://www.mysql.com/doc/en/InnoDB_Deadlock_detection.html> <http://www.mysql.com/doc/en/Error_handling.html> hth -- Best Regards, mds mds resource 877.596.8237 - Dare to fix things before they break . . . - Our capacity for understanding is inversely proportional to how much we think we know. The more I know, the more I know I don't know . . . --
pgp00000.pgp
Description: PGP signature