At 18:45 +1100 1/10/03, Ben Mooney wrote:
i have been using the following sql to try and get foreign keys
working, the table creation works fine but when i try and delete
data from the parent table it deletes as would normally happen in
mysql, also the desired results do not happen if i use RES
Dear Ben,
> i have been using the following sql to try and get foreign keys
> working, the table creation works fine but when i try and delete data
> from the parent table it deletes as would normally happen in mysql,
> also the desired results do not happen if i use RESTRICT.
> is this a problem
i have been using the following sql to try and get foreign keys
working, the table creation works fine but when i try and delete data
from the parent table it deletes as would normally happen in mysql,
also the desired results do not happen if i use RESTRICT.
is this a problem to do with indexes
