Martijn,
----- Original Message -----
From: ""Martijn Tonies"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, October 24, 2003 4:08 PM
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
> Hi Heikki,
>
> As you know - I'm a transaction zealot :-)
>
> Is there a way to get a signal back to the client when a
> transaction has started?
what do you mean? If you have AUTOCOMMIT=0, then every SELECT, INSERT,
UPDATE, DELETE starts a new active transaction.
BEGIN does not start a transaction inside InnoDB; it is the first statement
inside the BEGIN block which starts a new active transaction. BEGIN is just
an instruction to MySQL to group upcoming statements as a single
transaction.
If you mean 'event alerters', MySQL does not implement them.
>Or perhaps something like
> @@trancount in MSSQL?
What does it count?
> Is there a way to turn ON/OFF auto-commit?
SET AUTOCOMMIT={0 | 1}
> And, are metadata operations under transaction control?
CREATE TABLE, DROP TABLE, etc. form a transaction of their own. You cannot
use ROLLBACK to roll them back.
> With regards,
>
> Martijn Tonies
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM
tables
> Database Workbench - developer tool for InterBase, Firebird & MS SQL
Server.
> Upscene Productions
> http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
