You are using MyISAM tables which do not support transactions. You need to
convert your table to either BDB or INNOBASE type in order to use
transactions. All the info is in the manual..
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Tue, 10 Apr 2001, Bruno Ro
**READ THE MANUAL BEFORE POSTING TO THE LIST**
http://www.mysql.com/docs
On Tue, 10 Apr 2001, Bruno Roselli wrote:
> Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ?
>
> mysql> BEGIN;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> UPDATE tabgral set codigo=2 where cod
Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ?
mysql> BEGIN;
Query OK, 0 rows affected (0.00 sec)
mysql> UPDATE tabgral set codigo=2 where codigo=1 and nrotab=99;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> ROLLBACK;
ERROR 1196: Warn
