Multi-Table Referential Delete Clarification with MySQL 3.23.51

2002-07-29 Thread Sridhar Peddireddy
Guys, I know that version 3.23.51 of MySQL does not handle deleting data from multiple tables directly. I am in a situation where i have to delete millions of records from a dozen tables. The delete logic is not simple, i have to check a number of tables before i can actually delete a row from a

Re: Multi-Table Referential Delete Clarification with MySQL 3.23.51

2002-07-29 Thread Sridhar Peddireddy
Forgot to mention that all of my tables are of TYPE: MyISAM Thanks Sri [EMAIL PROTECTED] wrote: Guys, I know that version 3.23.51 of MySQL does not handle deleting data from multiple tables directly. I am in a situation where i have to delete millions of records from a dozen tables.