From: Andrew Moore
Date: May 20 2011 11:14am
Subject: Re: MySQL ignores foreign key constraints
List-Archive: http://lists.mysql.com/mysql/225056
Message-Id: <BANLkTikRTxVe-zW_GcOGpf0W_8v0YWmTnw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf304346d46c90bf04a3b338b6

--20cf304346d46c90bf04a3b338b6
Content-Type: text/plain; charset=ISO-8859-1

Try

show create table ... ;

A

On Fri, May 20, 2011 at 12:07 PM, Mimi Cafe <mimicafe@stripped> wrote:

> Hi
>
> An ideas why MySQL silently ignores any foreign key constraints I define
> for
> the following tables?
>
>
> mysql> desc book;
>
> +------------------+-------------------------------+------+-----+---------+-
> ------+
> | Field            | Type                          | Null | Key | Default |
> Extra |
>
> +------------------+-------------------------------+------+-----+---------+-
> ------+
> | pkisbn           | varchar(20)                   | NO   | PRI | NULL    |
> |
> | fkpublisher_id   | tinyint(3) unsigned           | NO   | MUL | NULL    |
> |
> | title            | varchar(50)                   | NO   |     | NULL    |
> |
> | subtitle         | varchar(50)                   | NO   |     | NULL    |
> |
> 13 rows in set (0.01 sec)
>
> mysql> desc book_author;
> +-------------+------------------------+------+-----+---------+-------+
> | Field       | Type                   | Null | Key | Default | Extra |
> +-------------+------------------------+------+-----+---------+-------+
> | fkauthor_id | mediumint(10) unsigned | NO   | MUL | NULL    |       |
> | fkisbn      | varchar(20)            | NO   | MUL | NULL    |       |
> +-------------+------------------------+------+-----+---------+-------+
> 2 rows in set (0.00 sec)
>
> mysql> desc author;
>
> +-------------+------------------------+------+-----+---------+-------------
> ---+
> | Field       | Type                   | Null | Key | Default | Extra
> |
>
> +-------------+------------------------+------+-----+---------+-------------
> ---+
> | pkauthor_id | mediumint(10) unsigned | NO   | PRI | NULL    |
> auto_increment |
> | fname       | varchar(20)            | NO   |     | NULL    |
> |
> | initial     | varchar(5)             | YES  |     | NULL    |
> |
> | lname       | varchar(20)            | NO   |     | NULL    |
> |
>
> +-------------+------------------------+------+-----+---------+-------------
> ---+
> 4 rows in set (0.00 sec)
>
>
> Mimi
>

--20cf304346d46c90bf04a3b338b6--