Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

Morten Gulbrandsen [EMAIL PROTECTED] wrote: mysql SHOW VARIABLES LIKE have_innodb; +---+--+ | Variable_name | Value| +---+--+ | have_innodb | DISABLED | +---+--+ 1 row in set (0.02 sec) mysql === Goodygood, Victoria

I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

Dear MySQL developers, Could some experienced Database developer please take a look at this ? It is supposed to be plain SQL2. How can it be coded under MySQL Especially all referential triggered actions. According to the manual : 7.5.5.2 Foreign Key Constraints Starting from version

Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

Hi, On Thu, Jul 31, 2003 at 02:46:06PM +0200, Morten Gulbrandsen wrote: According to the manual : 7.5.5.2 Foreign Key Constraints Starting from version 3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table type which allows you to define foreign key constraints

AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

Dear Fred, according to what I experience, I do definitely run the default binaries, perhaps the daemon mysqld has to be started with an option in order to support InnoDB ? How can this be investigated ? C:\mysql\binmysqld -v mysqld Ver 3.23.55-max-debug for Win95/Win98 on i32

Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

Morten, On Thu, Jul 31, 2003 at 03:27:51PM +0200, Morten Gulbrandsen wrote: according to what I experience, I do definitely run the default binaries, perhaps the daemon mysqld has to be started with an option in order to support InnoDB ? How can this be investigated ? Well, I never

Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

Morten Gulbrandsen [EMAIL PROTECTED] wrote: according to what I experience, I do definitely run the default binaries, perhaps the daemon mysqld has to be started with an option in order to support InnoDB ? How can this be investigated ? C:\mysql\binmysqld -v mysqld Ver

AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ? Hi, On Thu, Jul 31, 2003 at 02:46:06PM +0200, Morten Gulbrandsen wrote: According to the manual : 7.5.5.2 Foreign Key Constraints Starting from version 3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table

AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

But My SQL gives me TYPE=MyISAM ? Morten Gulbrandsen [EMAIL PROTECTED] wrote: according to what I experience, I do definitely run the default binaries, perhaps the daemon mysqld has to be started with an option in order to support InnoDB ? How can this be investigated ? C:\mysql