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
