**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 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
