When you delete a row from a table that may be referenced in another
table... you must delete all references to it from the other tables. This is
done in the same way in which you deleted the first row...
ryan
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> As long as MySQL doesn't manage the foreign keys, how do you manage
> the deletion of a record if it is referenced in another table's
> record?
> I am working in ASP, but I will be intersted by solution in any
> programming language.
>
> Thanks,
>
> Nicolas.
>
> passpharse : database,mysql
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 7.0.4
>
> iQA/AwUBOzrqB4iKIkRfAqJVEQKt1ACglEJufod2+1A6jHOWh+pDUqLhUJ0AoNTC
> 3UMqv+qnk9VUCtJkLznjH7w5
> =tmED
> -----END PGP SIGNATURE-----
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
