What is your default storage ?
Do this : SHOW ENGINES;
You should see something like this:
mysql> show engines;
++-++
| Engine | Support | Comment
|
+--
If I understand your question correctly - and I'm not sure I do - Table 2 is
the parent and Table 1 is the child. In other words, there is a one-to-many
relationship between the parent, Table 2, and the child, Table 1.
Therefore, if the parent table, Table 2, contains one row for each
departme
Vinita,
thank you for the bug report. The BLOB silently changes the CHAR(20) field
to a VARCHAR(20) field in te parent table. But the field in the child stays
CHAR(20).
There is a bug in ON UPDATE CASCADE which forgets to pad the field in the
child table with spaces. The child table becomes corru
Pierre,
Tuesday, June 11, 2002, 4:51:16 PM, you wrote:
PB> does mysql-max 3.23.50 support the option on delete cascade for the
PB> foreign key, the documentation is not very clear on this point
Yes, since 3.23.50 MySQL supports ON DELETE CASCADE and ON DELETE SET
NULL on InnoDB tables.
PB> Pie
[snip]
does mysql-max 3.23.50 support the option on delete cascade for the
foreign key, the documentation is not very clear on this point
[/snip]
No , it does not.
Jay
sql, mysql, query
-
Before posting, please check:
http
