List:General Discussion« Previous MessageNext Message »
From:Bruno Roselli Date:April 10 2001 6:53pm
Subject:BEGIN, COMMIT, ROLLBACK
View as plain text  
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       |                |         |
+---------+--------+------------+------+----------------+-------------+-----
----
--------+--------------+-----------+----------------+---------------------+-
----
----------------+------------+----------------+---------+



Thread
BEGIN, COMMIT, ROLLBACKBruno Roselli10 Apr
  • Re: BEGIN, COMMIT, ROLLBACKPeter Skipworth10 Apr
  • Re: BEGIN, COMMIT, ROLLBACKJohn Barton10 Apr