saiph <[EMAIL PROTECTED]> wrote:
>
> alea> mysql -V
> mysql Ver 12.22 Distrib 4.0.17, for pc-linux-gnu (i386)
>
> but
>
> mysql < SHOW VARIABLES LIKE "have_innodb";
> +---+---+
> | Variable_name | Value |
> +---+---+
> | have_innodb | NO|
> +--
alea> mysql -V
mysql Ver 12.22 Distrib 4.0.17, for pc-linux-gnu (i386)
but
mysql < SHOW VARIABLES LIKE "have_innodb";
+---+---+
| Variable_name | Value |
+---+---+
| have_innodb | NO|
+---+---+
1 row in set (0.09 sec)
why?
the gentoo eb
saiph <[EMAIL PROTECTED]> wrote:
>
> <- snip ->
> Because your tables are not InnoDB.
> Check if InnoDB is enabled:
> SHOW VARIABLES LIKE "have_innodb";
>
> <- snip ->
>
> no, InnoDB is not enabled. how can i enable it?
What version of MySQL do you use? 3.23.xx or 4.0.x?
If you use 3.23 you sho
<- snip ->
Because your tables are not InnoDB.
Check if InnoDB is enabled:
SHOW VARIABLES LIKE "have_innodb";
<- snip ->
no, InnoDB is not enabled. how can i enable it?
the referece manual show a my.cnf configuration for a machine with at least
2gb of ram and 60 of hard disk.
how can
saiph <[EMAIL PROTECTED]> wrote:
>
> i'm studing foreign keys but my sql code does not react as
> would imagine when i insert inconsistent data.
>
> i.e.
>
> create database urls;
> use urls;
>
> create table caths
> (
>name varchar(7) primary key
> ) type = innodb;
>
> create table urls
>
Don't foreign keys need to be explicitly indexed?
Respectfully,
Ligaya Turmelle
"saiph" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> hi list,
>
> i'm studing foreign keys but my sql code does not react as
> would imagine when i insert inconsistent data.
>
> i.e.
>
> create data
hi list,
i'm studing foreign keys but my sql code does not react as
would imagine when i insert inconsistent data.
i.e.
create database urls;
use urls;
create table caths
(
name varchar(7) primary key
) type = innodb;
create table urls
(
name varchar(10) primary key,
home varchar(
