* Nitin
> mysql doesn't support anything called rollback upto 4.0
This is not correct.
The concept of "rollback" is related to transactional table types, and both
InnoDB and BDB are available in the 3.23 version of mysql.
The first mention of "rollback" I could find in the manual was 3.23.17:
h
mysql doesn't support anything called rollback upto 4.0
Nitin
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "debug" <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 8:37 PM
Subject: Re: assorted
* DeBug
> >> How does one restore a mysql database if it crashes in
> >> the middle of a large operation?
>
> RB> Not sure what you mean...
>
> What if i on purpose turn off the computer when mysql is in the middle of
> transaction execution ?
Then someone should smack your fingers...! ;)
> Will
* Tofu Optimist
> Three questions from a Mysql newcomer
>
> Syntax question:
>
> Can a table in database A have a foreign key
> relationship with a table in database B? (both INNODB,
> both with appropriate indexes, etc)
Yes, but I suspect that you really meant foreign key constraints?
Constr
