transaction

[Anon]

I have mysql 3.23.22 version installed in windows. I have problems with using Rollback and Commit commands.They just don't work.Any suggestions?
And I would like to now how to create berkeley databases??

[Anon]

This is the syntax to create Berkeley tables:

CREATE TABLE whatever (name VARCHAR(10), number INT) TYPE = BDB;

johan

[Anon]

I have executed the following commands:

CREATE table test (id INT(8)) TYPE = BDB;
set autocommit=0;
begin;
insert into test values(12);
rollback;

But the value id=12 was inserted into the table test!!!
Why????

[melvyn]

Korhan wrote:

I have executed the following commands:

CREATE table test (id INT(8)) TYPE = BDB;

Try it again, and then followed by:

SHOW CREATE TABLE test;

You'll see that the table type is actually MyIsam, if you don't have BDB support.

Yes - it should report a warning 🙂.

[Anon]

Thanks.
I understood that it is not suporting BDB by MyIsam message.
My version is 3.23.21 and how can i make it support. In its manual it says it suports. Is -there a code to make it enabled.

[melvyn]

That's right - windows.......:
http://www.mysql.com/doc/W/i/Windows_and_BDB_tables..html

[kparker]

Just in case anyone else thinks that double-dot at the end of the URL is a typo, it isn't! Leave it there, and you'll get the page just fine.