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 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 codigo=1 and nrotab=99;
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1 Changed: 1 Warnings: 0
>
> mysql> ROLLBACK;
> ERROR 1196: Warning: Some non-transactional changed tables couldn't be
> rolled back
>
> show table status like 'tabgral';
> +---------+--------+------------+------+----------------+-------------+-----
> ----
> --------+--------------+-----------+----------------+---------------------+-
> ----
> ----------------+------------+----------------+---------+
> | Name | Type | Row_format | Rows | Avg_row_length | Data_length |
> Max_data
> _length | Index_length | Data_free | Auto_increment | Create_time |
> Upda
> te_time | Check_time | Create_options | Comment |
> +---------+--------+------------+------+----------------+-------------+-----
> ----
> --------+--------------+-----------+----------------+---------------------+-
> ----
> ----------------+------------+----------------+---------+
> | tabgral | MyISAM | Dynamic | 280 | 45 | 12872 |
> 429
> 4967295 | 7168 | 0 | NULL | 2001-04-10 09:17:45 |
> 2001
> -04-10 12:58:11 | NULL | | |
> +---------+--------+------------+------+----------------+-------------+-----
> ----
> --------+--------------+-----------+----------------+---------------------+-
> ----
> ----------------+------------+----------------+---------+
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
