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
