Begumisa Gerald M [EMAIL PROTECTED] wrote on 02/22/2005 02:03:43 AM:
Hi,
I'm writing an application that uses InnoDB tables to provide
transactional integrity. The front-end is a web-based interface.
I'd like to know - is there a way one can issue a query to test whether
a
particular
Hi
I must be blind. Please help a DB-Newbie. What's wrong here:
create table users (
email varchar (80) unique not null,
ownerdomain int not null,
foreign key (ownerdomain) references domains on delete cascade
) type=innodb;
MySQL sais: ERROR 1005: Can't create table
think
you'll see what's wrong with your statement. If you fix that, I think your
table will be created correctly.
Rhino
- Original Message -
From: Philipp Snizek [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, February 22, 2005 11:08 AM
Subject: RE: InnoDB Row Lock test (A query
Hi Shawn,
Thanks for taking time to respond to this.
[...]Usually the database sets and releases locks like that in
response to a series of statements on the order of sub-seconds, not
for the several seconds to minutes that may be required of an
application-level lock).