I have two tables, call them Parent and Child, where the records in Child have a foreign key relation to Parent, with a Cascade on Delete. If i delete records from Parent, the corresponding records in Child will be deleted. Is there any way that i can get a count of the records in Child that were deleted? without doing a 'Select count(*) FROM Child' before and after the delete?
Im writing a utility that sometimes deletes records, and we'd like to know how many from each table, and i'd like to take advantage of the cascade on delete. thanks sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]