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
>
