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
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
[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: