mysql中2008错误,在MySQL中是否有SQL Server的@@错误

I want to run an update query against a production database and as good little developer I am trying to make it as safe as possible. I am looking to do the following

BEGIN TRANSACTION

UPDATE table_x SET col_y = 'some_value'

.

.

.

IF (@@error <> 0)

BEGIN

ROLLBACK

END

ELSE

BEGIN

COMMIT

END

The above should work in SQL Server but I need this to work against a MySQL database.

EDIT:

Sorry, there is more than 1 statement to execute. Yes I am aware of not needing to wrap a single query in a transaction.

解决方案

I don't think this is necessary as there is the concept of implicit commit/rollback.

By default, MySQL starts the session

for each new connection with

autocommit mode enabled, so MySQL does

a commit after each SQL statement if

that statement did not return an

error. If a statement returns an

error, the commit or rollback behavior

depends on the error. See Section

13.6.13, “InnoDB Error Handling”.