[dba-SQLServer] Upgrade to MySql

Hi Stuart:

That is correct Stuart but check out Han's post on the subject. The question
is can the rollback be done via connection calls from ADO-OLE.

Are the following comments written by a MySQL programmer correct or just
dated?

http://www.draconianoverlord.com/2010/07/22/dammit-mysql.html

Jim




-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Thursday, August 12, 2010 5:12 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Upgrade to MySql

On 12 Aug 2010 at 14:52, Jim Lawrence wrote:

> There are a few good reasons for not going to MySQL. 
> 
> For example you can not roll back a transaction or series of
> transactions. For any application, that is at all like accounting,
> that is a big minus. 

http://dev.mysql.com/doc/refman/5.0/en/commit.html

MySQL 5.0 Reference Manual :: 12 SQL Statement Syntax :: 12.3 MySQL
Transactional and 
Locking Statements :: 12.3.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax

12.3.1. START TRANSACTION, COMMIT, and ROLLBACK Syntax

START TRANSACTION [WITH CONSISTENT SNAPSHOT] | BEGIN [WORK]
COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
SET autocommit = {0 | 1}

The START TRANSACTION or BEGIN statement begins a new transaction. COMMIT 
commits the current transaction, making its changes permanent. ROLLBACK
rolls back the 
current transaction, canceling its changes. The SET autocommit statement
disables or 
enables the default autocommit mode for the current session.

Beginning with MySQL 5.0.3, the optional WORK keyword is supported for
COMMIT and 
ROLLBACK, as are the CHAIN and RELEASE clauses. CHAIN and RELEASE can be
used 
for additional control over transaction completion. The value of the
completion_type system 
variable determines the default completion behavior. 
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com