Re: mysql and innoDB

2004-10-27 Thread Egor Egorov
Egor Egorov <[EMAIL PROTECTED]> wrote: > "Stefan Gnann" <[EMAIL PROTECTED]> wrote: > >> I have a mysql database 4.0.15 on a suse linux 9.x system running. > > First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/). > RPM version is easy to install and run. O

Re: mysql and innoDB

2004-10-22 Thread Egor Egorov
"Stefan Gnann" <[EMAIL PROTECTED]> wrote: > I have a mysql database 4.0.15 on a suse linux 9.x system running. First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/). RPM version is easy to install and run. > Now we have to use the features of InnoDB tables (rollbac

Re: mysql and innoDB

2004-10-21 Thread Heikki Tuuri
://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ - Original Message - From: "Gary Richardson" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, October 21, 2004 7:46 PM Subject: Re: mysql and innoDB Is there any

Re: mysql and innoDB

2004-10-21 Thread Gary Richardson
Is there any output from the command? Any errors? Try SHOW CREATE TABLE x. It should show you the TYPE= at the end. out. On Thu, 21 Oct 2004 11:10:10 +0200, Stefan Gnann <[EMAIL PROTECTED]> wrote: > Hi all, > > I have a mysql database 4.0.15 on a suse linux 9.x system running. > Now we hav

Re: mySQL and innoDB

2002-04-09 Thread Benjamin Pflugmann
Hi. Is there a chance that you make this behaviour dependend on the --ansi switch? I never used foreign keys until now, but from the theory I would expect that a missing "not null" declaration on a FK declaration should either be implicitly assumed or result in an error - at least on insert. I m

Re: mySQL and innoDB

2002-04-09 Thread Heikki Tuuri
ttp://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: ""Alain Del Giust"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, April 09, 2002 7:59 PM Subject: Re: mySQL and innoDB > "if you have a forei

RE: mySQL and innoDB

2002-04-09 Thread Rance Hall
> -Original Message- > From: Alain Del Giust [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 12:48 PM > To: Christopher Thompson; [EMAIL PROTECTED] > Cc: Rance Hall > Subject: Re: mySQL and innoDB > > > I am just testing mySQL so I will be able to

Re: mySQL and innoDB

2002-04-09 Thread Christopher Thompson
On Tuesday 09 April 2002 11:47 am, Alain Del Giust wrote: > I am just testing mySQL so I will be able to use it instead of Oracle > Sybase ... > > I am not saying a PK can be NULL wich is impossible > But a FK can be NULL and I'd like to know how to do that with mySQL I do not see this as being a

Re: mySQL and innoDB

2002-04-09 Thread Alain Del Giust
he employee who is at the top of the hierarchy as no manager ... so for A and B in the hierarchy table the foreign key referencing employee.employee_id is NULL Alain - Original Message - From: "Christopher Thompson" <[EMAIL PROTECTED]> To: "Alain Del Giust" <[EMAIL PROT

RE: mySQL and innoDB

2002-04-09 Thread Rance Hall
c. [EMAIL PROTECTED] -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 12:05 PM To: Alain Del Giust; [EMAIL PROTECTED] Subject: Re: mySQL and innoDB On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote: > "if you have a foreign key con

Re: mySQL and innoDB

2002-04-09 Thread Christopher Thompson
On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote: > "if you have a foreign key constraint, that field must be one of the values > of the referenced column and that column, being an index, is never NULL" > > OK so my understanding is that it is impossible with mySQL to do such > things wich

Re: mySQL and innoDB

2002-04-09 Thread Alain Del Giust
Enterprise Sybase Adaptive Server Anywhere Thanks, Alain - Original Message - From: "Rance Hall" <[EMAIL PROTECTED]> To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 6:42 PM Subject: RE: mySQL and innoDB

Re: mySQL and innoDB

2002-04-09 Thread taraben . a
b values ('BBB','aaa'); > works well > > Alain > > - Original Message - > From: "Rance Hall" <[EMAIL PROTECTED]> > To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Tuesday, April 09, 20

RE: mySQL and innoDB

2002-04-09 Thread Rance Hall
ssage- From: Alain Del Giust [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 11:45 AM To: Rance Hall; [EMAIL PROTECTED] Subject: Re: mySQL and innoDB Nope insert into b values ('BBB',null); here: BBB is PK of table b null is FK of table b referencing table a for exam

Re: mySQL and innoDB

2002-04-09 Thread Alain Del Giust
D]> To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 6:25 PM Subject: RE: mySQL and innoDB The "insert into b values ('BBB', NULL)" statement should fail under the conditions you describe, BBB was not inserted int

RE: mySQL and innoDB

2002-04-09 Thread Rance Hall
The "insert into b values ('BBB', NULL)" statement should fail under the conditions you describe, BBB was not inserted into the A table, and therefore the foreign key constraint fails as it should. Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc.