Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
mysql 4.1 rollback ?
problem is solved now. My my.cnf file contains the entry "skip-innodb" If i adapt this file and put this entry in comment. Restart mysqld Redo test It works now -
mysql 4.1 rollback ?
If i do exactly likes what is mention in section 15.7.1 page 807 of the MySQL Reference Manual 5.0.3-Alpha i get : mysql> use test Database changed mysql> create table customer (a int, b char(20), index (a)) type=InnoDB; Query OK, 0 rows affected, 2 warnings (0.05 sec) mysql> begin; Query OK, 0... -
-
mysql 4.1 rollback ?
See the create table statement : create table tran_test (a int, b int) type = InnoDB; i use InnoDB -
mysql 4.1 rollback ?
I am missing the create table statement; Attached the complete output: mysql> use test; Database changed mysql> set autocommit = 0; Query OK, 0 rows affected (0.00 sec) mysql> create table tran_test (a int, b int) type = InnoDB; Query OK, 0 rows affected, 2 warnings (0.04 sec) mysql> begin... -
mysql 4.1 rollback ?
i have installed mysql-server-4.1.8a-4 and mysql-client-4.1.8a-4 on Linux 2.6.9 mysql is working correctly; the rollback is not working : mysql> insert into tran_test (a,b) values (1,2); Query OK, 1 row affected (0.01 sec) mysql> select * from tran_test; +------+------+ | a...
